Formula to Use in Multi Select Column



I have a column that is set up as a multi select with four options in the drop down, and I would like tally of the total number of times each option was selected.

So for example, if my four options were Apples, Bananas, Peaches, Grapes, and people are able to select any or all of those options in a single cell, I would like a total of the number of times Apple was selected, a total for the number of times Banana was selected, etc.

I haven't had any luck with the formulas I have tried - does anyone have any suggestions?

Thanks so much!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!