Date filled in from selecting a checkbox

ClayBuell

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

 

Paul Newcome

Unfortunately this is not currently possible. Please see the post in the below link for some options...

 

https://community.smartsheet.com/discussion/auto-generate-datetime-field-data-based-upon-existing-column

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, the third-party service, Zapier is an excellent option for this scenario. You could also use the Smartsheet API. Is any of those an option for you?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD