Select Multiple Options
Hello,
I built a scheduling tool that contains several countries that are organized into regions. You can choose one or multiple countries in a form to schedule an event. I'm trying to make it so that if I choose to schedule an event for an entire region or in all regions, the user doesn't have to select each country individually. So by choosing a region or all regions, all respective countries would be chosen. Is there a way to do this?
Thanks in advance for your help!
Best Answer
-
What I would do in this instance is have one multi-select dropdown per-region. Then you can set up Conditional Logic in your form to only show the Region Countries if it's selected:
The default for these country columns could be that all values are selected, meaning the form user would need to de-select any countries they don't want from that Region:
An alternative would be to have a Change Cell workflow on your underlying sheet, so the Form User could identify if they want to select ALL or manually choose a few.
If they opted to select an entire region, you could auto-fill the correct column with the workflow:
I hope that helps!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
What I would do in this instance is have one multi-select dropdown per-region. Then you can set up Conditional Logic in your form to only show the Region Countries if it's selected:
The default for these country columns could be that all values are selected, meaning the form user would need to de-select any countries they don't want from that Region:
An alternative would be to have a Change Cell workflow on your underlying sheet, so the Form User could identify if they want to select ALL or manually choose a few.
If they opted to select an entire region, you could auto-fill the correct column with the workflow:
I hope that helps!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you! Those are some great ideas! I'll give them a try.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!