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


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,

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!