Community,
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)
-Clay