Populate a date field when checkbox checked

Options

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!