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
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.