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
-
- 99
- 0
- 1 day ago
-
- 1148
- 1
- Apr 4
-
- 330
- 1
- Mar 20
-
- 373
- 0
- Mar 14
-
- 547
- 0
- Mar 8
-
- 296
- 0
- Feb 21
-
- 276
- 1
- Feb 14
-
- 368
- 0
- Feb 13
- see all
Recent Activities
joeythelemur asked 1 day ago
How can I better organize a LOT of properties?discossstick asked Apr 4
settings of font colour changed?polle answered Apr 2
Where can we send feature suggestion to Notion so …
...