Numbers: How to insert a static timestamp based on a checkbox?

Will Numbers ever create a formula or function that allows a user to insert a static time stamp based on the checkbox in a cell? In Google search and Apple forums search, many people have asked for this over the years but Apple has not been able to this or wants to look into making this function available.


To be clear: In my Numbers spreadsheet, A2 would be a checkbox. When the box is checked, I want the B2 to insert the current date and time and not update to current date and time every time I open the spreadsheet.


I do not want to go through extra steps to achieve this and should not have to copy and paste into another cell.

MacBook Air 13″, macOS 26.6

Posted on Aug 13, 2026 12:55 PM

Reply
2 replies

Aug 14, 2026 7:29 AM in response to paradox414

Apple Numbers does not currently support a native formula or function to create a static, non-updating timestamp triggered by a checkbox. Because formulas like NOW() or TODAY() always recalculate when a sheet opens or updates, achieving a truly frozen timestamp without manual copy-pasting requires iterative calculation support or event-driven scripting neither of which Apple has built into Numbers. 

Numbers: How to insert a static timestamp based on a checkbox?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.