Formula Needed for Drop Down


Hi, I am looking for a formula that will allow me to limit the options seen in a drop down based of what is selected from another drop down. For example, Column A would is a State Drop Down and Column B is a City Drop Down but only shows the cities that are in that state. Is this possible? 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!