Count of dropdown options (like you can with a pivot table?)


I've created a quick Form to help my HR team collect votes from staff on 4 key areas. I've used the "Dropdown (multi select)" column type, and the Form asks staff to select the 2 options they rank as most important from these lists.

Is there an easy way to then see how many votes have been allocated to each option? Through a dashboard, or using formulas..?

For example:

Area 1, Option 1: 2 votes

Area 1, Option 2: 7 votes

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!