Populate a date field when checkbox checked


Hi. I need to populate a date field when checkbox checked. I tried using the following formula but the date changes each day to today's date. =IF(Checkbox@row = 1, TODAY())

This date field needs to record the day that the check box was checked keep that day for auditing purposes.

Obviously I am missing 1 more step to put the date it was checked into a date field that records that day and doesn't change again.

Any ideas?

Thanks in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!