Reducing selections based on previous answer

Options

Hello,

I am trying to have Question 2's selections change depending on the answer of question one. The reason is i don't want to make a bunch of different columns for each possibility. For instance:

Question 1:

A, B, C

Question 2:

1, 2, 3

If you select 'C' for Question 1, I want Question 2 to only display '3' as an option. Is that possible?

Thanks

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Dezmond

    I see you marked @Andrée Starå's response as not answering your question.

    The solution of having multiple columns that appear/disappear as fields in a form is what I would also suggest at this time. There isn't a way to make the actual options of the dropdown appear/disappear, you would need to make the entire field be conditional.

    Please provide your feedback to the Product team through this form, here.

    Cheers,

    Genevieve

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @Dezmond

    I hope you're well and safe!

    • Yes, with a Form and the Form Logic feature, but you'll need to add multiple so-called helper columns to make it work.
    • Another option could be the Premium App, Dynamic View. Is that an option?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    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.

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Dezmond

    I see you marked @Andrée Starå's response as not answering your question.

    The solution of having multiple columns that appear/disappear as fields in a form is what I would also suggest at this time. There isn't a way to make the actual options of the dropdown appear/disappear, you would need to make the entire field be conditional.

    Please provide your feedback to the Product team through this form, here.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!