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.
Pulling drop-down menu values from another sheet
I am trying to create a web-based order form. The item that people would be requesting is seperated into categories and then numbers.
I have these items listed in another sheet and would like customers to be able to select a category, which would then pull up the subset of items in that category (i.e. select category A which would then allow you to select from items #0001-0003.) We have 30+ categories and 700+ item numbers which is constantly being added to, so to have to scroll through all of those without selecting the category first might be a bit cumbersome, not to mention time-consuming when trying to add all of these to a drop-down value menu.
1. Is there a way to select a list of items from a list of categories?
2. Can Smartsheet pull these values from my other sheet?
I know that Excel is capable of this, but I didn't know if there was a way to do it in Smartsheet.