Select Multiple Options


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!


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Tim Dollmeyer

    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!



  • Tim Dollmeyer
    Tim Dollmeyer ✭✭✭✭

    Thank you! Those are some great ideas! I'll give them a try.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!