Google Sheets - Dependent Drop Down List for Entire Column, Multiple Levels

Learn how to create multiple level dependent drop down validation list in Google Sheets that works for the entire column. We'll be using JavaScript and Apps Script in this tutorial.

#googlesheets #dropdown #list

[anaisabelalvaradoh.]

I've literally watched about 8 different tutorials but yours is the only one that had exactly what I wanted and explained in an easy way, thank you!!!!

[KUMAR]

Great. I 55 and have discovered the wonderful world of coding. I'm learning and your videos are greatly helping. Thanks a lot and keep up the great work

[atropolifilm]

Perfect video. First time ever that I wrote an Apps Script and had to learn a lot in order to achieve a three-level dependent doplist. But you did a fantastic job in explaining all commands step by step. I am still no expert and can hardly describe the purpose of all the code I've written. But most of it makes sense to me and I have a general understanding of what every line is for. That shows how great this video was! It made me learn a very complex and fully new thing in less than three hours. You are my go-to expert for any questions related to Sheets :))) Keep it cocming! - Moritz

[nictoluxed]

Thank you so much for uploading these videos! I've been trying different solutions to the dynamic dependent dropdown list problem for my homebrew system. Found several ways how to make it work from the internet. Currently yours and Jason Jurotich's is the most comprehensive even though IMHO yours is the more dynamic and scalable. Always looking forward for your next uploads. keep up the good work!

[artbargra]

Thank you so much for doing this video! You don't know how long I looked for this, because we needed it for our sales spreadsheet. I don't have a background in coding nor programing, but your step-by-step explanation was crystal clear. The only problems I ran into were typos or me not handling commands correctly. After following it to the end, it worked like a charm.

Again, thank you very much!

[timdunn]

Will be using this to create a personal daily report card. (Woke up at 6a, meditated for at least 15min, green day trading, 30min walk, bed by 11p, etc, etc) then get a "grade" at the end of the day. Thank you for the solid instructions.

[DimitarSavov]

Gee, that was exactly what I was looking for! After watching your video like 4-5 times I managed to modify it for my needs and it is perfect! I cannot thank you enough! The only downside of using Scripts I think is that they're bit slow, but gets the job done nonetheless! Thank you once again, really informative and awesome explanation! Keep it up, bro! Respect <3

[craigianmenzies]

Took a bit of tweaking for what I needed but was a massive help, thank you for taking the time post it and step through the process.

[daweedcito]

Difficult to deny that coding is a great skill for most jobs right now

[ramclouddwightbungay]

I have extremely NO experience or knowledge about programming. But this video helped a LOT! Thank you kind sir.

[mreighties]

I have enjoyed watching and following along while working in an actual sheet and typing in the script in by hand. A few days ago I just tried something else and nothing worked so today I followed the video exactly and now it works perfectly. I have watched many of your videos and learned a lot. Some folks have ask for a sample sheet or that you provide the code but I think it is better to learn GAS by typing in the code instead of having the code given to you.


Excellent videos and look forward to doing some of the others.


James/mreighties :)

[aidenff]

This tutorial has been immensely helpful! I would definitely categorize my coding capability as amateur, but I found this very easy to follow. I have one question that I haven't seen in the comments yet. I've built a workbook that has repeated sheets for each month. I want to perform this function on each. How do I alter the script so on January, February, March, ...etc it performs this multi-level data validation to the same array of data?

Again - very impressed with how well you convey information.

[romannekrasov]

YOU ARE THE BEST! Solved my problem 100%
For those who would like to make ranges also autoupdateble try using function:
=UNIQUE('master'!A2:A999) on sheet "options" in cell A2
=UNIQUE('master'!B2:B999) on sheet "options" in cell B2
=UNIQUE('master'!C2:C999) on sheet "options" in cell C2
The only thing that I don`t know how to get rid of is error massage from data validation when you enter new items directly into the master`s sheet.
Let me know if you have an answer.

[julessmith]

Great video, just what I needed! Very clear, quick and nicely presented. Learnt so much doing it, especially having to closely follow your script and also type it in. Thanks.

[sgupta]

Great video tutorials. Hat's Off to you guys for useful contents. Wish there was some way to copy paste the code, either from the website or from the youtube description.

[wiganagames]

the best video that i could find. thank you!

[kennethlobo]

Used some techinques from this + the dynamic drop down video to build what I needed to. Thank you!

[DaniLong]

This is great!! Your walk through was so professional. Well done. AND, the script works so well.
Seriously, though, thank you for such a thorough walk-through of the code.

[aashitgarodia]

You're legend making everything so easy, feels like I can make google sheets work like any software. Thank you so much for making these wonderful videos so damn easily accessible to everyone!

[glagamayo]

I'm having trouble on the e.range, here is the error message: TypeError: Cannot read property 'range' of undefined