I have a data table and it includes a STATUS column and a COMPLETED DATE column.
I have a formula in the COMPLETED DATE COLUMN that automatically plugs in the current date if the value in the STATUS column is "Completed". That formula is
[pre]
[/pre]
This works great but only for today. When I bring the sheet up tomorrow, all the COMPLETED DATES turn to tomorrows date! Is it possible to FREEZE them so they put in the value of today's date one time, and then don't subsequently change it (unless the user makes a mistake and changes the value in the status column back to something else (like "Started") and then later changes it to Completed? And can I do this WITHOUT VBA?
I have a formula in the COMPLETED DATE COLUMN that automatically plugs in the current date if the value in the STATUS column is "Completed". That formula is
[pre]
Code:
=IF([@Status]="Completed",TODAY(),"")
This works great but only for today. When I bring the sheet up tomorrow, all the COMPLETED DATES turn to tomorrows date! Is it possible to FREEZE them so they put in the value of today's date one time, and then don't subsequently change it (unless the user makes a mistake and changes the value in the status column back to something else (like "Started") and then later changes it to Completed? And can I do this WITHOUT VBA?