Date filled in from selecting a checkbox

ClayBuell ✭✭✭
edited 12/09/19 in Formulas and Functions


I want a date to be filled in when I select a checkbox.  I came up with the following formula but supplies the current date.  I want the date cell to show the date that the checkbox was checked.

So for example, if I selected the checkbox on 09/01/19 the date column would display 09/01/19 even though the day I'm viewing/editing the sheet is 09/26/19

=IF([Application has been filed]@row, TODAY(0), 1)





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!