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

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.