Ask Questions

Connect

0vote

Need help comparing values of two multiselects

Asked
2837 Views
1 Answers
Solved

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.

by sonitre (180 points)

1 Answer

1vote

hypnotionlabs Points520

Hi!
This can be solved if you use two relations instead of two multiselects:

Video: https://youtu.be/VhZgJedhX-A
Will that do?
here it is

by hypnotionlabs (520 points)
selected by

0vote

polle commented

Sharing the formula and how it works for sure will help solving this and others with similar questions.

by polle (103k points)

0vote

hypnotionlabs commented

Strictly speaking, the task require solution for multiselect field. And I haven't completely despaired of finding it yet. There are still a couple of ideas left to try.

by hypnotionlabs (520 points)

1vote

sonitre commented

This is great, thank you! Would you mind sharing the formula for "Common value?"

by sonitre (180 points)

0vote

hypnotionlabs commented

by hypnotionlabs (520 points)

1vote

sonitre commented

Amazing! I got it to work! Thanks so much for your help

by sonitre (180 points)

Please log in or register to answer this question.

Related questions

Without Answer

Recent Activities

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Tags

Connect