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

[VitaliyG]

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!

[ScottWorld]

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