Help

Re: Formula for Table Lookup—Two fields, an ID string and a string in a Rollup

Solved
Jump to Solution
1376 0
cancel
Showing results for 
Search instead for 
Did you mean: 
VitaliyG
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for taking a look in this thread.

I am looking to create a zapier step that checks for a row in a table which contains 1) a certain ID (exists as string), and 2) to see if a certain string exists as part of a rollup.

How would I write the formula for this?

This is what I have so far… it’s good for finding rows that have only one item in the rollup, but if I need to find a certain item within a rollup, it says none exist.

AND({ID}=‘abcdefg123’, {Rollup}=‘xyz999999’)

Thanks again! Happy holidays!

10 Replies 10

Wow, this is great news! Will save a lot of hassle!