Formula for counting values from single-select drop down on a form

Hello,

I'm trying to figure out how i can count or which formula i can use to count how many people selected their desired choices from three different categories (single-select dropdown) that falls under 3 different groups. I created a form out of a sheet and my question is when people are going to pick their top 3 choices for each of those 3 categories what can i do or use to count those selections on the sheet. Let me know if you have any additional questions or if this all makes sense. I was thinking to use Count formula but then I am thinking do i have to put that formula under each column (9 columns for 3 categories).Ex:

1-    Goals for the next 1-3 months:

a)     First Choice: (Single-select dropdown)

b)    Second Choice: (Single-select dropdown)

c)     Third Choice: (Single-select dropdown)


2-    Goals for the next 3-6 months:

a.     First Choice: (Single-select dropdown)

b.     Second Choice: (Single-select dropdown)

c.     Third Choice: (Single-select dropdown)


3-    Goals for the next 9-12 months:

a.     First Choice: (Single-select dropdown)

b.     Second Choice: (Single-select dropdown)

c.     Third Choice: (Single-select dropdown)

Best Answer

«13

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!