How to count rows with more than one selection in a drop down menu?

edited 06/22/22 in Formulas and Functions

Hello you pros, I looked for an answer but was unsuccessful.

I have a column with a multi-select dropdown menu. The selections are for product categories in the cannabis industry (flower, edibles, concentrates, vapes etc)

I have found a working formula to count how many projects have a single category (thank you community!).

How do I count the projects that involve more than one category? I just want to report how many projects are multi-category no matter if they have 2,3 or 4 categories affected by the project scope.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!