Drop down list with hierarchy
I want to create 2 related drop down list, For example, first column drop down "A, B , C" choice, 2nd column have "A1, A2, B3, B4, C5, C6. When I choose "A" in 1st column, only "A1, A2" can be chosen in 2nd column.
Is ti possible?
Thanks.
Daniel
Best Answer
-
Hi Daniel,
It's not possible to conditionally format a single dropdown list like this, please submit an Enhancement Request when you have a moment!
As an alternative, you could create multiple columns: The first column is the initial drop down list, then a specific column just for A (with A1, A2, etc), one for B (with B1, B2 etc), and so on.
Then if these selections are done via forms, we recently released a new feature in forms where you can use conditional logic to have certain columns/form fields appear based on previous selections. This means that if A is selected from your first drop-down list, it would only show A's column (without showing B's column or C's column).
You can read more about this in our Help Center (see here), or sign up for one of our upcoming Webinars on the new Forms feature in May: https://help.smartsheet.com/learning-track/best-practice-webinars/webinars
Cheers,
Genevieve
Answers
-
Hi Daniel,
It's not possible to conditionally format a single dropdown list like this, please submit an Enhancement Request when you have a moment!
As an alternative, you could create multiple columns: The first column is the initial drop down list, then a specific column just for A (with A1, A2, etc), one for B (with B1, B2 etc), and so on.
Then if these selections are done via forms, we recently released a new feature in forms where you can use conditional logic to have certain columns/form fields appear based on previous selections. This means that if A is selected from your first drop-down list, it would only show A's column (without showing B's column or C's column).
You can read more about this in our Help Center (see here), or sign up for one of our upcoming Webinars on the new Forms feature in May: https://help.smartsheet.com/learning-track/best-practice-webinars/webinars
Cheers,
Genevieve
-
Thank you for the answer, Genevieve. Hope Smartsheet could develop this feature soon, I already submit this request.
-
This is also a feature that I need, in addition to being able to dynamically create a drop down list based on the entries of a column in the same or other sheet.
-
I agree with Rebeca. The ability to only change the entries for a drop down list in the edit column feature is so 1990's. Please create the enhancement. The ability to make changes, for example of a contact list, across many sheets would be amazing. I have members being added, switching or leaving teams on a consistent basis. If I were to have a single source on one sheet would be amazing.
-
Any update on this topic? Is there an enhancement request out there to get this functionality available?
Help Article Resources
Categories
Check out the Formula Handbook template!