Help

How can I count the number of similar linked record between two columns?

671 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tsukasa_Tanimot
4 - Data Explorer
4 - Data Explorer

Hi, I need help with the following.

On sheet 1, I have a list of tags as primary fields. Let’s say “outdoor”, “indoor”, “both”.

On sheet 2, my primary field is people. People have preferences of places to go out to, so I tag people using “link to another record” and tag them with one or two of the tags from sheet 1.

On sheet 3, my primary field is a list of places. Similarly to with people, I tag places using “link to another record” and tag them with one or two of the tags from sheet 1.

How can I compute the number of tags that a person and a place share together?

Thanks a lot in advance.

0 Replies 0