Filters for Multi-Select Drop Down Column

Jayy S.

I have a column in my sheet that allows multi-select in a drop down. I want to create a filter that will show me all the rows that have multiple values selected in that column, how can I create a filter for that?

Paul Newcome

You would need a helper column on the sheet to output how many selections were made on each row.

=COUNTM([Dropdown Column Name]@row)

Then you would filter based on this helper column being greater than one.

Paul Newcome

When you say "multiple", do you just mean any row with more than one, any row with at least one of a certain selection, any row that has all of the specified selections, or any row that has exactly the specified selections?

Jayy S.

I mean just any row with more than one, nothing specific.

Paul Newcome

You would need a helper column on the sheet to output how many selections were made on each row.

=COUNTM([Dropdown Column Name]@row)

Then you would filter based on this helper column being greater than one.