Force ranking in a survey
Has anyone ever leveraged in a survey the ability to provide a list of options and have the survey user force rank the top 5? How would you set up the sheet/form to have them see the total list (15) and then force rank their top 5?
Best Answer
-
Hi, Martha. Unfortunately, forms (even with logic) don't really support this. Here's a help thread that might be of use to you: https://community.smartsheet.com/discussion/85336/add-a-ranking-list
I set this up somewhat differently, because you have so many choices.
Each column has the same drop-down choices (15 total). I then created a form (image below) that requires the user to select one of the 15 options for each of their top 5.
Per Genevieve's article linked above, you can use the data you collect to count, sum or average options in the Sheet Summary or on a separate worksheet to identify the top choices among your respondents or to show the distribution of choices in a graph.
Answers
-
Hi, Martha. Unfortunately, forms (even with logic) don't really support this. Here's a help thread that might be of use to you: https://community.smartsheet.com/discussion/85336/add-a-ranking-list
I set this up somewhat differently, because you have so many choices.
Each column has the same drop-down choices (15 total). I then created a form (image below) that requires the user to select one of the 15 options for each of their top 5.
Per Genevieve's article linked above, you can use the data you collect to count, sum or average options in the Sheet Summary or on a separate worksheet to identify the top choices among your respondents or to show the distribution of choices in a graph.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives