Hello!
I'm trying to set up a Zap that does the following:
When a new spreadsheet (sheet A) with a certain title is created in Drive, I want to read the data from one column in sheet A and match it against a column in a different worksheet (sheet . Whenever there is a value matching, I want a counter in the cell adjacent to the matching one in sheet B to be incremented by 1.
So far I have the trigger: Event = "New Spreadsheet", then a Filter: check if new sheet title contains certain text.
But now I'm stuck on the next action, which should be something like: if values in column in sheet A match values in column B in sheet B, update/increment adjacant cell to matching cell in sheet B.
Is this in any way possible, even just a partial success of the above? Or am I asking too much of Zapier here?