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

0vote

Need help comparing values of two multiselects

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.

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

0vote

polle commented

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

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.

1vote

sonitre commented

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

0vote

hypnotionlabs commented

1vote

sonitre commented

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

Please log in or register to answer this question.

...

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!

Connect