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.

Need to build formula that includes a drop down menu as an option, need advice

Kevin Wiechelt
Kevin Wiechelt ✭
edited 12/09/19 in Archived 2015 Posts

I am trying to build a formula that includes a drop down menu as an option.

 

This is what I am trying to do ...

 

=IF([COLUMN1] = "Campus name", then [BUILDING NAME], otherwise "Please select your campus before selecting the building name")

 

* COLUMN1 would be a drop down menu with campus names

* BUILDING NAME would be a drop down list of building names on the previously selected campus name.

 

Can anyone gives me tips on how to reference drop down menus in a formula?

Tags:
· Share on FacebookShare on Twitter

Comments

  • JamesR
    JamesR ✭✭✭✭✭✭

    Kevin,

    You will need a dropdown for each campus with the relevent thier Building Names. The formulae would then need to be in each Dropdown column that loohs at the campus name and says either NA or select from here.

     

    Understand that once they make thier selection it would over writethe formulae.

    · Share on FacebookShare on Twitter
  • Greg Hawk
    Greg Hawk ✭

    I am confused by what you want the formula to do. It sounds like you want users to select a campus then select a building, correct? Is the formula just telling the user to select a campus first or do you want to building list to reflect the selected campus? 

    · Share on FacebookShare on Twitter
  • Kevin Wiechelt
    Kevin Wiechelt ✭

    If possible, I need a drop down menu to select from a list of campuses. Then, a drop down building menu for the selected campus. 

     

    Not sure if its possible to build this into my Smartsheet, but it sure would be helpful.

    · Share on FacebookShare on Twitter
  • Greg Hawk
    Greg Hawk ✭

    You can have a dropdown list for your campuses and one for buildings - it sounds like you want the second list to update dynamically, correct? This isnt possible to Smartsheet but there may be another way to set this up. 

     

    As James suggested, you could have a different dropdown column for each campus. Users can just locate their campus, then select the building from the list.

     

    Will users be adding data directly to the sheet or through a web form?  

    · Share on FacebookShare on Twitter
  • Kevin Wiechelt
    Kevin Wiechelt ✭

    Users would be adding through a web form. I would like the second list to update dynamically. I think it may just be a limit of what the smartsheet can do. I will need to come up with a work around. Thanks for your help.

    · Share on FacebookShare on Twitter
  • Greg Hawk
    Greg Hawk ✭

    You might consider using Google forms, which can do the logic you are looking for. Google forms can show options based on what the user selects.

     

    With Smartsheet Sync, Google form entries can be added to a Smartsheet. Check it out: http://help.smartsheet.com/customer/en/portal/articles/1850129-smartsheet-sync-add-on-for-google-forms

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories