Updated: Oct 30, 2022
Start from scratch:
If you've ever created a dashboard in Excel, you've probably added Data Validation drop down lists for selectors. Once you start to add a few in that may relate to each other, you'll find that it would be nice if each list reduced to only the applicable items based on the choices from the other selections. In this video, we'll look at how to make that happen! You'll need dynamic arrays (Office 365) for this.