Hello all,
I’m trying to create a zap to capture who’s responding to a ticket that I’ve already captured in smartsheet. For my previous zap which captures the ticket, I have this flow in place:
This is how my smartsheet looks like after a few tickets have been created:
Now, someone is going to respond to the original email that created these rows to say that they’re working on the ticket. To capture that and update the Assignee column (and potentially the rest of the columns) this is the flow that I’ve come up with so far:
I’m using the Filter conditions to look for any email starting with RE: CSR to capture those that are replies to those rows. Then, I’m trying to see if that matches any of the rows that I have on smartsheet, but I don’t know the syntax works in the Query section of the configure tab of the Find sheet Row.
I’d greatly appreciate it if someone could help me with the syntax or maybe an even better flow for capturing what I’m trying to do.
Thanks.
