Using Logic to Autofill Other Fields in a Form

I have a form where a user would select options from a drop down. Ideally, like to setup logic so that when they select option D, there is another form field (let's just call it Field 2) that is then hidden and has its value set. There are other times when if they were to chose Option C, they would need to decide what choice to make in Field 2. Is this currently possible?

Answers

  • Hi @Hayden Helms

    No, there currently isn't a way to set both of these types of Conditional Logic on the same form. You could either have it hidden, and only submit the default value if option D is chosen, OR you could have it hidden to then appear when option C is chosen to allow selections.

    That said, although you can't build the logic directly into the form, there's a way to achieve your end goal by using the underling sheet capabilities!

    What I'd do in this situation is set up the form to have Conditional Logic only showing Field 2 if Option C is chosen.

    Then, set up a Change Cell Workflow when rows are added to the sheet which checks to see if Option D is chosen, and if it is, sets a specific value in the cell:


    See: Change the Value of a Cell in an Automated Workflow

    Will this work for you?

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!