There's a quiet frustration baked into this question, and it's one we understand completely. You've built the checkbox, you've got the cell ready for the timestamp, and then you hit the wall: the exact moment you check that box, you want the time locked in, frozen until you deliberately clear it and start over. On Excel for Mac, online, and iOS, that simple ask suddenly feels like you're trying to bend time itself. But here's the truth: the solution isn't about finding a hidden setting or a clever formula trick. It's about accepting that the tools you're using weren't built for this specific kind of permanence, and that's okay. You're not doing anything wrong. You're just pushing a spreadsheet to do something it never promised.
What you're really asking for is a snapshot, not a calculation. A formula like `=IF(A1=TRUE, NOW(), "")` works in the moment, but it recalculates every time the sheet updates, which means the timestamp shifts like sand. That's why the desktop app feels like the only escape hatch: it offers iterative calculation, a way to tell Excel to stop recalculating that one cell after you've made your choice. Without that, you're stuck with a live clock where you need a frozen one. So what do you do when the tool you have refuses to hold still? You work around it, not through it. You can use a script, if your version supports it, or you can change your workflow entirely. Maybe you log the time in a separate cell manually, or you use a different app that treats checkboxes as events rather than states. The point isn't to force Excel to be something it isn't. It's to recognize that your need for a locked timestamp is a need for a record, not a formula.
The practical takeaway here is that your constraint isn't a failure of imagination. It's a signal that the feature you want is a product decision, not a user error. When a tool makes you jump through hoops to capture something as simple as "when did I check this box," that's not a limitation you should have to code around. It's a gap in the product. And while you can't fix that gap from your iPhone, you can make a choice: either accept the manual step, or find a tool that treats time as a first-class citizen. The moment you stop fighting the spreadsheet and start questioning why it's so hard, you're already on the path to a better workflow.
So here's our concrete suggestion, not a platitude: if you can't get the desktop app, don't look for a formula that pretends to lock time. Instead, build your tracker around the idea that the checkbox is a trigger, not a timer. Use a separate column for the timestamp, and make it a habit to tap it right after you check the box. It's one extra tap, but it's reliable, and reliability beats cleverness every time. Or, if that feels like too much friction, try a dedicated tracking app that logs timestamps natively. Your time is worth more than a spreadsheet's stubbornness. The tool should serve the record, not the other way around.