Help between Notion users

It's free & easy

Receive points, vote and give the solution

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.

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?

0vote

### polle commented Jan 24, 2023

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

0vote

### hypnotionlabs commented Jan 24, 2023

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 Jan 25, 2023

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

0vote

1vote

### sonitre commented Jan 25, 2023

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

...