Dynamic dropdowns - Waterfall request
Options
Comments
-
I support this. Any update from anybody at Smartsheet product ownership?
-
+1 for this feature request
My company is using a form to assign trailers to yard locations, but we need to restrict the dropdowns by facility(PA warehouse vs. TX warehouse) and type(dock door vs. parking spot). In the current state, the form would require users to select from hundreds of options. This leaves much room for error, as users could mistakenly assign a trailer to a parking spot at the wrong facility and cause confusion for both warehouses. How can we restrict assignment options without creating a new sheet for each facility?
-
Best method would likely be having a drop down selecting either PA or TX, and creating a column for both next to it.
If using forms, ask TX or PA and use "Logic" to only ask PA if PA is selected, and vice versa.If using sheets and filling those in only, I would conditional formatting. If "Location" is "PA', then apply (grey/black) to "PA-trailer" cell, or something like that.
-
I need to create two related dropdown lists, with the values displayed in List 2 dependent upon what was entered in List 1. For example, List 1 dropdown "A, B, C", List 2 dropdown "A1, A2, B1, B2, C1, C2. When I choose "A" in List 1, only "A1, A2" can be chosen in List 2.
-
Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.
