Multiselect column

#1

How to find Unique values from a Multiselect column?

0 Likes

#2

You are right, Since Multiselect column will throw out data in a more complicated format, binding it straight to a list type control will not work.

You can use the following way to list out the unique values from a multiselect column:

UNIQUE(FLATTEN(LOOKUP([sheet.multiselectcolumn])))

Point to note here is that a function called as FLATTEN() is used to first flatten the multiselect data into a list type data and then run UNIQUE() on top of it.

Hope this helps.

P.S: Since we are also Beta testing a feature to write your own FUNCTIONS() do let me know if you would like to test run the same and build magical Formulas and Functions.

0 Likes