Populating a Date field

Dee Barnard · 08/08/18

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 · 08/08/18

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 · 08/08/18

This is how I do it in Zapier:

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

Craig

Populating a Date field

Comments

Help Article Resources

Categories