I have one cell that indicates the status of a project. And then multiple other columns that are intended to mark the date of when the project changes status.
| Status | Date Project New | Date Project Uploaded | Date Project Completed |
|---|---|---|---|
| New | =IF(A2=”New”,NOW(),””) | =IF(A2=”Uploaded”,NOW(),””) | =IF(A2=”Completed”,NOW(),””) |
The issue is when the status column changes then the date that was recorded in previous stages is now erased. How can i setup a formula (or set of formulas in hidden columns if needed) that will record the day and then lock so it wont change anymore even after Status has changed?
I have tried the above formulas but clearly those dont work. I have looked up circular references to see if that will help but I dont think its a good long term solution especially if I need to change the number of iterations of formulas because there are other formulas in the spreadsheet that i dont want impacted.
1