Populating a Date field

Dee Barnard

I am trying to populate an Actual Start Date field with the current date when a checkbox is checked (Task Started).  I am using the TODAY feature in my formula for my Actual Start Date. But what I am seeing that when I open my sheet it populates all of those dates with TODAY's date so I loose the actual date that the task started.  I do not want that date field to update every day,  I want it to be the day the Task started. Is there another date that I can use that will capture the actual date but not update every day but stay stagnant?

Paul Newcome

Smartsheet does not have a fixed timestamp feature. The only options at this point are to either use a Modified (Date) column and never update the row once the box is checked, or to manually enter the date.

J. Craig Williams

This is how I do it in Zapier:

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

Craig