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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!