Hi @apay
Good question.
GSheets doesn’t provide the before/after value for a cell.
You can achieve this by using another column to track the last value. “Deadline Date - Last”
Essentially, after the Zap runs to add the new row to the other GSheet, then you’d update the original GSheet with the new value for future reference.
Hi @apay! How are you? Just wanted to pop in and see if you needed any further assistance. Let us know!
*Edited to move to a thread
Hi @apay! How are you? Just wanted to pop in and see if you needed any further assistance. Let us know!
Getting closer but not solved yet on my side!
Hi @apay
Good question.
GSheets doesn’t provide the before/after value for a cell.
You can achieve this by using another column to track the last value. “Deadline Date - Last”
Essentially, after the Zap runs to add the new row to the other GSheet, then you’d update the original GSheet with the new value for future reference.
Ah, so a multi-step zap?
I’m still not sure how, once the “Deadline” value is edited, triggering the Zap, you would send the old value to the “Deadline-Last” column.
it seems like once the edit takes place, the zap is triggered but the pre-edit value is lost?
if anyone can outline what the zap steps would be, I would really appreciate it!
@apay - checking in to see how are coming along with this Zap, let me know if you need any help or have any other questions.
Best,
Rachael