Multiple answer sets in one drop down column?
Is there a way to have multiple answer sets in a column when building an assessment form? For example, if the answer to question 1 is either 'yes' or 'no', and the answer to question 2 is a choice from 'never', 'rarely', 'sometimes'... If the questions are listed in column 1, can column 2 be set up for multiple answer sets?
Best Answers
-
If I'm following the question correctly, I think no. Forms only interpret columns as questions. You cannot set rows as a question in a form. For example, if you have a 25 question form, you will need 25 columns.
Travis C, PMP
Smartsheet Leader with 5+ years of SS experience
Let's connect: LinkedIn - Travis C.
If my answer was sufficient, pleaseupvote and mark my response as answered.
-
Hi @Everett
I hope you're well and safe!
Here's a possible workaround or workarounds
- You could maybe add multiple columns combined with the Form Logic feature.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
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.
Answers
-
If I'm following the question correctly, I think no. Forms only interpret columns as questions. You cannot set rows as a question in a form. For example, if you have a 25 question form, you will need 25 columns.
Travis C, PMP
Smartsheet Leader with 5+ years of SS experience
Let's connect: LinkedIn - Travis C.
If my answer was sufficient, pleaseupvote and mark my response as answered.
-
Thank you. Your answer helps. What I was hoping for is to be able to have a selectable set of answers that was different depending on the question. For example, column one has 20 questions, five of which require 'yes' or 'no' answers. So, if a column 1, row 1 question gives a choice of four answers and I set it up in column 2 to have those four options, I cannot make column 2, row 2 have 'yes' or 'no' as a selectable choice instead for that question?
-
Hi @Everett
I hope you're well and safe!
Here's a possible workaround or workarounds
- You could maybe add multiple columns combined with the Form Logic feature.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives