Ask Questions

Connect

0vote

Need help comparing values of two multiselects

Asked
3245 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 (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 (520 points)
selected by

0vote

commented Jan 24, 2023

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

by (103k points)

0vote

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.

by (520 points)

1vote

commented Jan 25, 2023

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

by (180 points)

0vote

commented Jan 25, 2023

by (520 points)

1vote

commented Jan 25, 2023

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

by (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