Formula to use to count multiple choice answers in a column by answers

Options

I'm trying to figure out the right formula to use to count multiple choices answers in one column in my sheet. I'm hoping to have this information roll up into a dashboard. But, for the cells that have multiple boxes/answers checked, it is only counting the first answer, not the others. Any suggestions?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!