I’m an “amateur” Zap user so I hope this doesn’t sound like a simple/stupid question :-)
I have a Google Sheet with many columns of data, including some that have dates.
I’m trying to create a Zap that sends Emails when I change the Date in one particular column. That’s the easy part. What I can’t figure out is how to make it so that if/when I re-sort/re-order the lines on the spreadsheet, the system doesn’t think I’ve changed the Date in EVERY row.
EXAMPLE:
Sheet is sorted in Alphabetical order, so the Line I change is Row 10. I understand how to make this action occur.
But if/when I re-sort the Sheet by the order of a different column, ALL the rows are reordered and the system then thinks I’ve changed the Date in ALL of the rows and the action is triggered for every row.
I just need the action linked/tied to that one row regardless of re-sorting and so the system won’t respond every time I re-sort the Sheet.
Does that make sense?
Any help you can provide is appreciated.