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.

Can you link drop boxes in a web form?

Lynn Craven
edited 12/09/19 in Archived 2016 Posts

I want to be able to select your name and your assigned support person populates the next block

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 02/29/16

    Lynn,

     

    If you aren't talking a lot of people, then nested IF's are what you are looking for

     

    =IF([Select Name]1 = "Bob", "Alice", IF([Select Name]1 = "John", "Sasha", "unassigned"))

     

    This example will look at the [Select Name] column.

    If it finds "Bob", then it will show "Alice" as the support person.

    If it finds "John", then "Sasha" gets the nod.

    Otherwise, there is not a dedicated support person yet, so it will be "unassigned"

     

    However, Contact List type columns can not have formulas, so this won't show up on Resource Views, if you use them.

     

    Hope this helps.

     

    Craig

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 02/29/16

    Sorry, just noticed the title of the thread.

     

    If you want to the support person to be shown in the WebForm, that is not currently possible. The formula won't update while the data is being entered and doesn't really "exist" until the form is submitted.

    By then, it is too late for the person entering the data to get that sort of feedback.

     

    Craig

This discussion has been closed.