Add a ranking list
Hello,
I am new to this site and fairly new to Smartsheet. I would like to provide a list and have participants rank the list by providing 1,2,3 etc to indicate their preferences.
Can anyone provide a formula for this please?
Thank you.
Answers
-
Hi @BAM2020
How are you setting up your sheet and asking people to provide their preferences? It sounds like you may want to have the list be one-item-per-Column.
Each column name would be the List Item. I would set this up as a DropDown List with 1 - 5 as options. Then you can create a Form for your users to fill out per item.
I would have one row at the very top of the sheet that simply uses =SUM([Column Name]:[Column Name]) to add together all the values for that one item.
Then you can use the Top Row in a Pie Chart Widget on a Dashboard and see which item has the highest Percent (or do other calculations).
If this isn't what you're looking to do, it would be helpful to see a screen capture of your current sheet and a detailed explanation of how your users are providing their responses, but please block out sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hello Genevieve,
Thank you for your response. I unfortunately don't have a screenshot to share, but maybe I can do a better job of describing what I am looking for.
We would provide a list of geographic locations and we would like respondents to rank their choices in order of preference.
Here is an example, we provide the following list:
Boston
New York
Atlanta
Chicago
Dallas
Los Angeles
San Francisco
And then ask them to number them in order of preference. We won't be tallying any numbers, but instead interested in individual responses. I hope that made sense.
Betty
-
Hi @BAM2020
Thanks for this additional information! What do you think of the set-up I suggested above?
You can have each column represent a different location. Then you can also include an extra column that is a "Created By" System Column to record the email address of the user who submitted the form.
So the form set-up could look something like this:
Note that you'll need to have the security settings on the form set so that it captures the email address in order to record it in the Created By column.
Is this what you were looking to do?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hello Genevieve,
Yes, this is pretty much what I am looking for, much appreciated!
I might have more questions, but for now, this info is great.
Thank you!
-
No problem at all! I'm glad I could help.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!