today() function

Shaun Hutch

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

 

 

Travis

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.