What formula do I use to count individual items in a multi-select dropdown cell?


I am trying to count individual items within a multi-select cell so that I can reflect the data in a chart in a Dashboard.

For example: If I want to find out how many people chose "Travel --- Reimbursement" in a multi-select field, how do I count just the "Travel --- Reimbursement" if various cells have other items in it (i.e. Travel --- Reimbursement, P-Card Payment, and Admin Tasks).

Any suggestions would be greatly appreciated!



Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!