are elements of a multiselect field in another multiselect field?

Joachim Mund

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

Leibel S

@Joachim Mund

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)