Skip to main content

Hi all,

I have two tables: Projects and Tasks. Each task has one or more municipalities. What I'd like to do is check if all the municipalities in each task associated with a particular project are the same. I initially thought I could do this with a rollup and ARRAYUNIQUE(values) and a comparison of the Municipality field with the rolled up field. As you can see below "Glenville, Rotterdam" is a match, but that is not what I am looking for. I only want a match if all the fields are exactly the same.

Any ideas on how to achieve this?

 

Hmm, so only the second record matches, is that right?  Could you provide screenshots of how the data's set up in the original base so that I can try to recreate your setup and figure out a solution for you?  If you could provide an example base that'd be ideal

Thank you for the response. I realized the solution as I was typing out an explanation. I had some "yes" and some "no." I just needed to roll up that "yes", "no" field and reject any that had at least one "no." Thank you again. 

Reply


Terms & Conditions