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
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
-
- 335
- 0
- Apr 29
-
- 1287
- 1
- Apr 4
-
- 413
- 1
- Mar 20
-
- 417
- 0
- Mar 14
-
- 360
- 0
- Feb 21
-
- 342
- 1
- Feb 14
-
- 424
- 0
- Feb 13
-
- 423
- 0
- Feb 11
- see all
Recent Activities
joeythelemur commented Apr 29
How can I better organize a LOT of properties?amandabee selected an answer Apr 29
Adding a basic feedback form to pages in a Notion…amandabee answered Apr 29
In Notion, I want the “Title” column to be filled …amandabee answered Apr 29
How can I better organize a LOT of properties?
...