Copy a date from one cell to another when a status changes
I am looking for a formula to to copy a date from one cell to another when the status changes to "In Progress". The formula below works but every time the date in cell 1 changes it changes in cell 2 because the status is "In Progress". I only want the date to copy to cell 2 when the status changes to "In Progress" the first time and not change going forward if the the date in cell 1 changes. I want to copy the date from Cell 1 to Cell 2 and freeze the date in Cell 2. To be clear the date I want to copy is not the date the was put "In Progress"
Cell 1 "Due Date"
Cell 2 "Original Due Date"
I have the following formula in Cell 2
=IF(Status@row = "In Progress", [Due Date]@row)
Help Article Resources
Check out the Formula Handbook template!