Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
today() function
I want to create a formula tht creates a Datestamp of when a checkbox is clicked.
If I use the today() function the date will keep going up. Is there a way to lock a date to the day a checkbox is clicked?
Thanks,
Shaun
Comments
-
Hi Shaun - as you have seen the TODAY() will change each day. If checking the box is the LAST thing you will do in a row, you could use the Modified (Date) system column which shows a timestamp of the last time the row was modified.
If you care more about being able to find out when the box was checked and less about the date being displayed in your sheet, you could view the cell’s history which will show you all the changes that were made, who made them, and when they were made. To view the history of a cell, right click in the cell and select View History.
