Stack Ranking 1 to 100
Hello,
Would like to seek your help.
We are doing a team survey on a list of 100 food items.
And we want our member to go to each it them item and stack rank them from 1 to 100
Ask :
Requirement is that each member could choose a value only once in the list.
Example :
the member will choose a value for 100 for "spaghetti bolognese"
he / she could NOT select 100, for item "pizza margherita" ,
he / she could only select any other number from 1 - 99
Could this be done if so how.
Thanks in advance
Seng
Answers
-
Hi @Seng
I hope you're well and safe!
I recently developed something similar for a client using the Form Logic feature in Forms, but I don't think it will work with that many options.
You could use a sheet instead as a workaround and show a message when they select a rank already used.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Seng - agree with Andrée. Can't currently be done in a form as such. My solution would be to do it in a sheet and if you want to enhance the user experience, give them a report to do this in and use a flag to highlight ones used more than once (see image). They can then refresh the report to sort it. You can also add a section showing the rankings not used so they can reference that. Suggest using a dropdown for the ranking to restrict entries to the range you allow.
This solution clearly depends on how many people you're getting to do the ranking as you'd need to copy the sheet and report so each user has one. Also assumes Smartsheet access so this would be for internal use and not scalable for external surveys
Let me know if you want more details on this.
Rich @ Prodactive Project Solutions
Rich Coles
Prodactive | Smartsheet-aligned Platinum partners
Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration
-
Thanks Team for the suggestion and fast response
-
Happy to help!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives