Build questions in a form based on rows, not columns
Is this possible?
I have a checklist sheet, with multiple questions set out in each row. Id rather avoid making each question a column so would it be possible to create a form based on the questions in the first column for each row?
Thanks,
Jack
Best Answer
-
Happy to help!
The simplest would still be to add the questions to the columns and also add a comment column for each question/section. (I created a solution with the comments section gathered by section but still possible to comment on each question in the section with text already in place in the field) Make sense?
I also had a client recently that I almost maxed out the columns because the form was so thorough. It was an Intake process similar to yours.
Another option would be to have a look at third-party service/integration. Google Form, for example, could be set up with conditions, but it would still require the columns.
What do you think?
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
-
Hi Jack,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
There might be a workaround.
What kind of questions is it? Yes/No?
How many different questions?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
-
Hey Andree,
Thanks for the prompt response as ever.
The questions require a Yes / No / N/A however this is also a column for 'Comments'. In the interim, id like to be able to just have the yes / no / N/A answers but if you could then put a comments box below each one to expand upon it that would be great too.
Enhancement request submitted and also screenshot attached, no sensitivities, just a generic checklist for programmes / projects.
Cheers,
Jack
-
Happy to help!
The simplest would still be to add the questions to the columns and also add a comment column for each question/section. (I created a solution with the comments section gathered by section but still possible to comment on each question in the section with text already in place in the field) Make sense?
I also had a client recently that I almost maxed out the columns because the form was so thorough. It was an Intake process similar to yours.
Another option would be to have a look at third-party service/integration. Google Form, for example, could be set up with conditions, but it would still require the columns.
What do you think?
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.
-
Thanks Andree,
Ill give the column ago and see how I get on 😊
Jack
-
You're most welcome!
Sounds like a plan!
Let me know how it goes and if you have any questions!
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
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives