are elements of a multiselect field in another multiselect field?
Hi all,
how can i find out if all elements of a multiselect field are contained in another multiselect field?
Example 1:
Multicell Field "Value1" has: "a d"
Multicell Field "Value2" has: "a b c d"
Answer: true, all values from "Value 1" are in "Value 2"
Example 2:
Multicell Field "Value1" has: "a d"
Multicell Field "Value2" has: "a b c e"
Answer: false, not all values from "Value 1" are in "Value 2"
Thank you and have a nice evening, Joachim
Answers
-
you can create an additional column that combines the 2 multi select column:
=JOIN([multicell1]@row:[multicell2]@row, CHAR(10))
Your formula to evaluate them would be:
=IF(AND(COUNTM([multicell2]@row) = COUNTM(multicellcombined@row), COUNTM(multicellcombined@row) > 0), 1, 0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!