Count when multiple drop-down selections are chosen

I have a "Project Type" column that allows for multiple drop-down selections: Manufacturing Site Change, Process Change, Vendor Change, etc. I am trying to count each individual project type even if multiple selections have been made in a single cell; e.g., if I've got Manufacturing Site Change and Process Change both selected in the same cell, I need to count each of them. I've tried COUNTIFS, but I haven't had success. Any help is appreciated!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!