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.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!