How to count answers in a dropdown column

Hello - I have a survey I created via a form and one of the questions is a dropdown menu where people can select 3 topics they'd like to learn more about. Is there an easy way to count how many times people selected each topic? We want to see what the top topics people want to learn more about are.
Thank you for the assistance!
Best Answer
-
You can use COUNTIF with the HAS function.
=COUNTIF([3 Topics would like more info]:[3 Topics would like more info], HAS(@cell, "Value you want to count"))
This will count the number of cells in the column that contain the value you want to count.
Example:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
You can use COUNTIF with the HAS function.
=COUNTIF([3 Topics would like more info]:[3 Topics would like more info], HAS(@cell, "Value you want to count"))
This will count the number of cells in the column that contain the value you want to count.
Example:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you so much! I was on the right track using the COUNTIF formula but I didn't know about the HAS feature. That worked perfectly! :)
-
Awesome, glad to help. I like the HAS function, it's like a sooped-up version of CONTAINS. Once I figured out how the HAS function works, I rewrote part of the help page for it because it used to be just a hastily rewritten copy of the CONTAINS help page and described the functionality wrong. (The example grid at the bottom of the HAS page is still wrong though!)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives