Keeping Original Date in another cell


Hello, I want to copy the original ECD (estimated completion date) we set for our projects into another cell automatically while allowing the users to be able to change the ECD dates. What we want to do is set our Original ECD and then over time as we update the ECD dates be able to check the "Original ECD" date to see how far off we were from our estimate.

Is there a formula or automation we can use to set this up?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!