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
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?