Formula to sum the number of selections made in a multi-select dropdown?

steven.nienaber105336

I have a dropdown with a total of 9 possible selections, but for formula purposes, I want to have a column represent how many of those selections were made. Therefore, if all 9 were selected, I want a cell to represent the number 9; 8 selected, the cell to represent only 8, and so on... The dropdown selections are words.

Thank you,

Kelly Moore

Hey @steven.nienaber105336

There is a function specifically made to count the number of selections in a multi-select dropdown

=COUNTM([your column]@row)

https://help.smartsheet.com/function/countm

steven.nienaber105336

Fantastic! Thank you, much appreciated!

Kelly Moore

Hey @steven.nienaber105336

There is a function specifically made to count the number of selections in a multi-select dropdown

=COUNTM([your column]@row)

https://help.smartsheet.com/function/countm

steven.nienaber105336

Fantastic! Thank you, much appreciated!