Скачать или смотреть Easy Hack to Add Multi-Select Dependent Dropdowns in Google Sheets

If you've been wondering how to add dependent dropdowns to the multi-select dropdown feature in Google Sheets, this is a no-code way to accomplish this, and I walk you through how to build this step-by-step.

You can make a copy of the final demo file here: https://bit.ly/3XELr9f

** EXTRA TIP **
You can set the color of the chips when you are adding the category dropdown, to the left of each option you can pick a color to go along with it. You can add colors to the items as well, once you add the first dropdown, BEFORE you drag it down to apply the dropdown to the entire column, select all the options in the first category field so all the options will show up in the first item field. Then you can pick the colors for all the options, then drag that dropdown field all the way down and you will have colors for all the categories and all the items.

** MORE INFO **
If you want to check out the original dependent dropdown video, that also goes into how to do multiple levels of dependent dropdowns, you can check that out here:    • Effortless Dynamic Dependent Dropdowns Tri...