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!
Best answer by Troy Tessalone
View original