Populate a Date field when a status is changed


I need to populate a "Start Date" field to TODAY() when my Status is changed to "In Progress"

I can write a formula but the Start Date is removed when the status changes to "Completed".

How can I populate the field and keep the value even if the status is changed?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!