Select Multiple Options

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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    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!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    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!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • Tim Dollmeyer
    Tim Dollmeyer ✭✭✭✭
    Options

    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!