All Content
Timespan
Dependent Drop-Down: a use case example with Microsoft Lists
Image Source: Shutterstock.com
Oct 1, 2022 8:39 PM

Dependent Drop-Down: a use case example with Microsoft Lists

External Blog Post

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:

https://github.com/Fedes365/Microsoft-Lists-Templates/wiki/Ford-or-Toyota%3F-A-Dependent-drop-down-men%C3%B9-with-Microsoft-Lists

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.

https://www.youtube.com/watch?v=7mo4COng7Sg