PM's - How can I take a date from one cell (which gets deleted) and make it the value of another cel

We're creating our Preventative Maintenance system in Smartsheet and need the "completed date" value to become the "last service date" value. Key factors:

1) the "completed date" needs to be removed in order for the automations and reports to run properly.

2) the "next service date" is "last service date" + "PM frequency"

I need a formula that will take the "completed date" and KEEP IT in the "last service date" column even when the "completed date" is deleted (which is 24 hrs after it is entered).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!