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

Jennica

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).

Paul Newcome

You would need to have some kind of unique identifier on each row. Then you would create a second sheet and set up a copy row automation (one the first sheet sending to the second sheet) that will copy the row each time the Completed Date column is changed to something that is not blank.

You would then use a MAX/COLLECT to pull in the most recent date from the second sheet based on the unique identifier for that row.