Dependent dropdown with multiple selection in Google Sheets

In this tip, we will learn how to create dependent dropdowns with Google Apps Script. Nothing new, right? But this time, you may select multiple items!
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below

[@eduardapacheco4394]

Hi!!
Can I do with no code?
I'm trying doing with this code but is not working

[@practicalsheets]

Very soon Sheets will implement multiple dropdowns functionality directly (in a couple of weeks), I would wait so you may do it without code
Kind Regards

[@rosalbakai7171]

How do you add this code or formula to more sheets

[@practicalsheets]

I have answered in the multiple dropdown video for Sheets
czcams.com/video/0FLPpHyiMkA/video.html&lc=UgyRYKmvCxhh5L_XA1V4AaABAg
Kind Regards

[@maryl3212]

Great video! Can you make multiple selections in the first column and filter the dependent dropdown for all of the selected values?

[@practicalsheets]

Hmmmm
Very interesting
How would you do if you select 4 options? you bring the suboptions for all 4?
Kind Regards

[@maryl3212]

@@practicalsheets yes, filter the dependent dropdown for all values chosen.

[@practicalsheets]

@@maryl3212 I think it may be done. A bit complicated but I think it's doable
Regards!

[@DaniaAnwar-l2l]

@@practicalsheets Is there any video for multiple selections in the first column and filter the dependent dropdown for all of the selected values?

[@practicalsheets]

@@DaniaAnwar-l2l Hello
Wow!
Expert level alert!
I suppose it could be done, but I don't have a video
Kind Regards

[@PjAyzB]

Hi, I cannot proceed with the multiple dropdown from the formula that you gave from this video czcams.com/video/0FLPpHyiMkA/video.html. I was trying to do it from the start but it gave me the same result. and to add I want to have my multiple dropdown from column 2 to 3-50 rows and to add the following columns. (2-9)

[@practicalsheets]

You are trying to do the project from this video, or the one you link?
Regards!