I have a Google Sheets to Google Sheets zap.
In spreadsheet A (“Projects”), the zap watches for changes to a column (“Deadline Date”).
When a “Deadline Date” is changed, I create a row in spreadsheet B (“Date Changes”).
I’d like to include the Project Name (easy), the new “Deadline Date” value (also easy), and also the PREVIOUS value (basically so I can see the new deadline date and the original date it got changed from.
I can’t figure out how to grab the original date value – help!
Hi
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
*Edited to move to a thread
Hi
Getting closer but not solved yet on my side!
Hi
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!
Try these steps...
Best,
Rachael
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.