Populate Start and End Dates with Today based on status

Detrie Zacharias
Detrie Zacharias ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

My sheet has Start Date, End Date and Status columns

My formula in Start Date is

=IF(Status@row = "In Progress", TODAY())

My formula in End Date is

=IF(Status@row = "Complete", TODAY())

 

My problem is the date values disappear when the status changes. How can I make the Start and End Date values stick once the field is populated?

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!