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

Shaun Hutch
edited 12/09/19 in Archived 2015 Posts

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?








  • Travis
    Travis Employee

    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. 

This discussion has been closed.