How to count the # of multi selected items from a drop down selection?

Jason Fruhschien

I have a column that has 5 selections from a drop down, and allows for multi-selection. Is there a way to count the number of times 1 selection was made, 2 selections were made, 3 selections were made etc.?

I tried using CountM, but I was not able to get the formula to produce the expected results, if any. Any idea on how to do this?

Eric Law

Hello @Jason Fruhschien , can you explain? You can do, =COUNTM([multi-selection column]@row) as your formula and it should populate. A screenshot would help in assisting with what you want to do.

Austin Smith

@Jason Fruhschien

=IF(CONTAINS(result 1, dropdown column@row),1,0)+IF(CONTAINS(result 2, dropdown column@row),1,0)+....

Adds one for each matching result for a total of options selected in the cell.

If you want a more complicated version, see the following link:

https://community.smartsheet.com/discussion/comment/370321#Comment_370321