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([email protected] = "In Progress", TODAY())
My formula in End Date is
=IF([email protected] = "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?