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.
Connect
Notion Answers
Help between Notion users
Register & Ask
It's free & easy
Get answers
Answers, votes & comments
Vote and select answers
Receive points, vote and give the solution
Question
1 Answer
Hi!
This can be solved if you use two relations instead of two multiselects:
Video: https://youtu.be/VhZgJedhX-A
Will that do?
Related questions
- Check if text is already mentioned in another column
- Need help to make progress that will be responsive to Status in second database
- Possible to save values of properties in different locations?
- How do I created a status formula based on the status/presence of multiple variables?
- I am looking for a formula that will auto-generate the full path of each tag.
Without Answer
-
- 40
- 0
- 5 days ago
-
- 76
- 0
- Mar 14
-
- 209
- 0
- Mar 8
-
- 195
- 0
- Feb 21
-
- 167
- 0
- Feb 14
-
- 225
- 0
- Feb 13
-
- 208
- 0
- Feb 11
-
- 224
- 0
- Feb 8
- see all
Recent Activities
Christian20032025 asked 4 days ago
Formula for an automation that sets due-date to ne…amandabee selected an answer Feb 24
Can I use a button to create a calendar event for …Barbora commented Feb 24
The Filters in the databases don't disappear.
...