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

Kevin Wiechelt

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?

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.

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? 

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.

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?  

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.

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