Help

Compare same field in linked records

Topic Labels: Formulas
212 2
cancel
Showing results for 
Search instead for 
Did you mean: 
s_t_mac81
4 - Data Explorer
4 - Data Explorer

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?

Screenshot 2024-10-17 at 9.29.39 AM.png

2 Replies 2

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

s_t_mac81
4 - Data Explorer
4 - Data Explorer

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.