I am working on creating a smartsheet form solution where users can rank their choices (1st, 2nd, 3rd, etc.). I want to avoid users to select same ranking for each option. Is there a way to create a form like that?
I hope you're well and safe!
Yes, you could use the Form Logic feature, and if they select 1st as the first choice, it will only show 2nd and 3rd as option for the second choice and so on.
Would that work/help?
I hope that helps!
Have a fantastic week & Happy New Year!
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 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
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
HI @Andrée Starå,
Thank you for your response. Can you please explain a little bit more? I know the logic in the form but couldn't made it work. Lets say users has 4 options (apple, orange, strawberry, and pear) and I want them to rank these as their choices. How can I set the form that if user select Orange as the first choice, then the second choice list only shows the remaining 3 options, and so on?
Happy to help!
Yes, I'll get back to the post.
@Andrée Starå any follow up on this ? From what I can tell, Smartsheet forms do not support ranking type questions but maybe I am missing something.
@Andrée Starå I have the same question. Could you explain how to use the form function in this exact case for the ranking?
@Andrée Starå , any answers to this post regarding ranking for forms within smartsheets? this question has not been answered.
I have data in Excel that I need to import on a weekly basis into Smartsheet (lets say columns A-F) I would like to have columns (lets say G-H) with formulas. How do I import data each week replacing the previous week's data (only columns A-F) without overwriting the formulas? Is it possible to do this via Datashuttle or…
We had a Latest Comment column but the Column Type wasn't accurate. Showing as a Text / Number type. I tried to resolve this and I get the error "There is already a Latest Comment column in the sheet". To try to resolve, I created another column and deleted the original. However this still hasn't fixed the issue. There are…
Hi everyone, my colleagues and I are new joiners to smart sheet, we all have pro plan licenses, but when I share a sheet with them with Admin access for each and every one of them they still don't see the Filter CHOICES I added in the Task Bar (to the right of the dropdown for changing the view), any idea why that is? I…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.