Multiple Selections from a Drop Down

Hi, am creating a smartsheet to collect certain client information & documents to provide a certain service. While creating a form which could be sent to my clients, I've realised that it only allows for a single selection of a document off all the documents that I've listed in the drop down. However I need multiple documents (if not all) to process the service request.

Am I missing a trick here ? Is there are workaround ?

Thanks in advance for your help.

Rgds, Ankit

Find more posts tagged with

Forms

Sheets

Services

Legal

Support

IT & Operations

Comments

Marcin P

Hi,

there is no possibility to mark up more than one choice within forms, but if your list isn't too big, then make each selection in separate column which is formatted as a checkbox. Then add them into your webform. At least this is the way how it works in one of my tools, so maybe it will work for you as well.

Marcin

Ankit Kochar

Thanks Marcin. Solves part of my problem.

Andrée Starå

Hi Ankit,

If you have a longer list, you could use a third-party service like Google Forms or similar to make multiple selections.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

What would the other part of the problem be?

Mike L.

Yes google forms is often a workaround for missing smartsheet functionality. If you want dependent dropdowns you can use google forms because smartsheet doesn't do that.

Ankit Kochar

Thanks Andree, would try that solution. However would seek one more clarification as to whether the data collected via Google forms is integrable with Smartsheet as the workflow (task distribution and execution) has been set up here ?

Ankit Kochar

Hi Paul, the other part would be to have 'responsive forms' (defined below) per service selected by the user.

'Responsive forms' - would have fields appear basis the primary selection, it might involve collection of multiple documents and this list could be large.

Rgds, Ankit

Ankit Kochar

Thanks Mike, will try the Google forms feature as well. However wanted to integrate the information collected with workflow which I'd created in Smartsheet not sure if possible in Google Forms.

Rgds, Ankit

Andrée Starå

Happy to help!

Yes, it is. Smartsheet integrates with Google Forms thru a connector called Smartsheet Sync.

https://www.smartsheet.com/apps/google-forms-smartsheet-sync

Would that work?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…