Populating a Date field

Dee Barnard
Dee Barnard ✭✭✭
edited 12/09/19 in Formulas and Functions

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!