0vote

Need help comparing values of two multiselects

Asked Jan 23, 2023

3211 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.

asked Jan 23, 2023 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

answered Jan 24, 2023 by hypnotionlabs (520 points)

selected Jan 25, 2023 by sonitre

0vote

polle commented Jan 24, 2023

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

commented Jan 24, 2023 by polle (103k points)

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.

commented Jan 24, 2023 by hypnotionlabs (520 points)

1vote

sonitre commented Jan 25, 2023

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

commented Jan 25, 2023 by sonitre (180 points)

0vote

hypnotionlabs commented Jan 25, 2023

Sure thing! The one with relations is here: https://4business.notion.site/sonitre-comparing-values-of-two-multiselects-b595f991a54941e1be6bf73256ba6c95

commented Jan 25, 2023 by hypnotionlabs (520 points)

1vote

sonitre commented Jan 25, 2023

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

commented Jan 25, 2023 by sonitre (180 points)

Please log in or register to answer this question.

...

Need help comparing values of two multiselects

Please log in or register to add a comment.