Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Compare same field in linked records

Topic Labels: Formulas
385 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.