Populate Start and End Dates with Today based on status
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
Check out the Formula Handbook template!