Need a formula to compare 2 lookup fields that have multiple values

[Anirudh_Subrama]

Hi… Here’s my scenario

Table 1 has one column called Tags and has multiple single word values

Table 2 has the columns: Phrase, Primary, Secondary and Tertiary.
Primary, Secondary and Tertiary are linked records and contain tags from Table 1. Multiple tags exist in each column

I need a formula that checks if primary, secondary and tertiary has common values.

[Justin_Barrett]

Welcome to the community, @Anirudh_Subramaniam! :grinning_face_with_big_eyes: Unfortunately a formula won’t let you do that. You would need to iterate through all of the tags in each field, comparing them against all of the tags in the other fields, but Airtable doesn’t contain any functions for iterating through collections of items. The only way to do that currently is with a script. It could be one that’s manually run via the Scripting app, or one that is part of an automation that triggers under certain conditions.

[OfficeOurs]

See my reply here