How to count rows with more than one selection in a drop down menu?
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.
Help Article Resources
Check out the Formula Handbook template!