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.