Capture cell changes in automation

Andrea Zenner

Hello,

We have an application that tracks users' PTO requests. Sometimes they need to change the date on which they are taking vacation. We have an automation that runs, when a date is changed, to notify their approver to re-approve the request.

I can change the message for changes so the approver knows it's for a change but they don't know what the change is.

Is there a way to capture the cell contents before and after the change so the approver can see what has changed? Or are we going to have to rely on the employee to type that into a comments field?

markkrebs

The only way I can think of is to copy the row everytime the request is made and in the 'copied row' sheet do a counter by person and grouped request ID then look at the most recent row-1 for the request and Index match that back into the original sheet. Somewhat complicated.... Other that that I think you'd need to rely on the requestor. I hope someone has a simpler solution because this is a common need. Smartsheet should put this as a standard feature as they capture all cell history but dont really do much with it in reports or use case like this.