Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Dependent Picklist in a Web Form

Options
Chris Goodman
edited 12/09/19 in Archived 2015 Posts

Is there way to have a dependent picklist in a webform? 

Tags:

Comments

  • Travis
    Travis Employee
    Options

    Hi Chris, I dont quite understand the question - could you please clarify? 

  • Maaik Meijerink
    Maaik Meijerink ✭✭✭✭✭
    Options

    I asked the same question some time ago. I think/hope Chris means: a data driven picklist, just like the contactlist, but now based upon values from a sheet.

     

    To get even more sophisticated: a cascading picklist/dropdownlist would be great:

    Simple example:

    - PL1. Picklist with Buildings

    - PL2. Picklist with Floors within the selected building in PL1

    - PL3. Picklist with Rooms within the selected Floor in PL2

     

  • Chris Goodman
    Options

    Maaik - yes this was what I was looking for.

    PL 1 - Grade

    PL 2 - Classes offered (potential overlap between Grades)

    PL 3 - Teachers of classes (potential overlap between Classes)

     

    You're a mind reader.

  • Travis
    Travis Employee
    Options

    Thanks for clarifying! This is possible using Google Forms and Smartsheet Sync. Google Forms allow you to set conditions for forms (If this is selected, show these options). Smartsheet Sync can add data entered from Google Forms, into a Smartsheet.

     

    Here's information on how to set this up: http://help.smartsheet.com/customer/portal/articles/1850129 

This discussion has been closed.