Dependent Drop-Down: a use case example with Microsoft Lists
When it comes to tracking data, sooner or later Microsoft365 users may need to the available options in a drop-down menu by Federico Sapia
Dependent Drop-Down: a use case example with Microsoft Lists
Microsoft365 users who track data may at some point need to dynamically display the choices in a drop-down menu based on whether or not one or more requirements are met elsewhere. For instance, Microsoft Excel formulas provide this capability.
Now it's Microsoft Lists turn and thanks to some JSON formatting features we can track data and use a drop-down menu conditionally, based on previous choices.
A special thanks to Ami Diamond for his helpful testing and feedback
Link to GIT Repo:
Support Links
Dependent Drop Down List in Excel Tutorial
In this step-by-step tutorial, first we learn how to create a basic dropdown list in Microsoft Excel. Next, we look at how to create multiple dependent drop-down lists.
https://www.youtube.com/watch?v=vh2jdOQ5VLs
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)
Learn how you can create MULTIPLE dependent data validation lists in Excel on the SAME sheet. In this video I'll show you a solution that requires ONE single formula. This formula also excludes blank cells on the bottom of the data validation list.