Hi, I'm trying to write a formula to see if two multi-selects share a common value. For example, one column is "User Style" that is a multi-select with keywords representing a the user's style (minimal, practical, etc.). The second column is "Item Style" with keywords representing an item of clothing's style (minimal, 70's, etc.). I want to write formula that returns true if "minimal" appears in both columns.
Help between Notion users
Register & Ask
It's free & easy
Answers, votes & comments
Vote and select answers
Receive points, vote and give the solution
This can be solved if you use two relations instead of two multiselects:
Will that do?