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!

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

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!

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.

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

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

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.

Legend, followed it step by step and it works! Couldn't make two functions out of it, so created another else if so my second function works as well. Brilliant!

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!!!!

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!

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

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 :)

have to tell you man, been watching ur videos here and there and you are absolutly didactic, really thanks for your effort and congratz for all of this! regards from brazil, tnx again

This is what i've been looking for , thanks man , keep up the good work !

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.

This was super useful - just the right level and speed - learnt much more than I was looking for. Thank you Sir.

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.

Thanks a lot. Had to modify some stuff to fit my purpose, but you are so clear. You are excellent!

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

you are an amazing tutor and helped me so much over the last 2 years, i cant thank you enough man, i really appreciate you!

Thank you so much for teaching all of this and so patiently!

just exactly what i need factions improve in my Project! Thanks Bro!

Great content, did fix my problem after a few adjustments from the example in the video, good job!

Thats your "on fire mode" (just feels like that) in this third ddvl video is a plus point Sir :)

the best video that i could find. thank you!

Very well done. This was very thorough and helpful.

This REALLY helped me out! Thanks so much!

Thank you so much! The video is so well explained and amazingly useful! Great job!

Amazing! Helped a lot! Thank you very much!

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

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.

If I love you? What is love anyway, but it was most certainly very helpful. Thank you!

Нашла то, что искала! Наконец-то! Большое спасибо!

Your videos are just brilliant. It helps to make Google Sheets work like ERP - thereby offering a pocket friendly turnaround on small businesses. Request to create a library of the Appscripts from where the codes can be copied & implemented easily.

Thank you so much! This is the best channel for learning google sheets with appscript! Keep going!

Great! Thanks, much helpful!

You're going so fast in this video! -your previous was slow and steady and ive been able to catch up. This one i need to pause, LOL. Good job by the way! love your videos!!

Thank you so much, works very well!!!

Thank you for this video!

Suppprrbbbb... Completed my database management system because of you thankyou soo much ❤️❤️❤️❤️❤️❤️

Thank you so much for detailed instructions. Further Question: I’d like to know whether it is possible to select several options(multi-select) in one cell on the column of “Sales_Rep” based on this script? Thank you:))

Thanks for this!

Thank you very much for your great video! Helped me a lot!!!

Thank you so much for videos!

Thank you for the awesome tutorial! I am running into some speed issues with the script's calls. I have a large file with many options and dropdowns. Do you have any advice on how to consolidate the calls to speed up my dropdown fields? Thanks.

Great!! Thanks so much.

Too helpful.. 👍The way you explain step by step make my work much easier to learn and implement at the same time

Great video, think I want to learn more now.

Great Job!!!

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.

You are amazing. thank you for the video. saved my life

Great job with the presentation

Any chance you can post a pic or something of the entire final version of the script? i followed your video step by step but im getting an error and also my play/run arrow is grey and i cant make the script run. thought maybe i missed something.

hi Thank you so much This topic has helped me a lot in the field of work

You saved me, thanks!!!

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.

If it was possible to double my like, I would have. Thank you because it is been a while I was looking for this

I'd like to add "Other" option in the first column so that next raw in the second and third level columns would be blank and allow type in a custom text. How should I modify the code for that?

Thank you so much!

Hi! Thank you very much for the tutorial. Is it possible to make the script run for several similar tabs? Let it be "master", "main" and "check"? What changes are needed inside the script? Thank you in advance!

Such a great Video!

I would absolutely love to see a video where this is optimized to work with any number of columns in the "options" sheet

After two days of watching on this lol .... I was able to create drop downs for 4 columns with no previous Javascript experience thanks so much!!! For everyone else who is watching with the same background some tips: Case matters, kept getting an error on the range but it was because I had getrange instead of getRange. Also if you end up adding more functions for more levels remember you have to update the array on top. I am wondering does anyone know how to clear a different validation that wouldn't be from the underlying structure? In this example let's say there was a fourth column was title (junior or senior) and you created the data validation on the master sheet just by referencing that range instead of creating rows for record. In the script is there a way to create a rule when you clear the region it clear this other validation?

Obrigado !!! Parabéns pela explicação

Hi! Any script for invoice, when I click on Submit button save on drive ,make database on another sheets, and open new empty invoices with new number? Thank you!

Fantastic tutorial!!! How would you change the script to paste the 3rd column of data automatically? I only have one item to paste in the third column so it doesn't make sense to have to select it. I would like it to automatically paste the third column of data from the 1st two selected.

If I only have one option available for my secondary or tertiary lists (e.g. In the example above say "Matthew" is the only Sales rep for TN in the Southern region) How can I have that automatically appear if there are no other options in the dropdown menu? In my case, I have a series of Projects > Unique Project IDs > Timezones where those projects are occurring. I'd like the UID to appear in the secondary validation automatically instead of clicking to select it.

Thank you for all the video tutorials, extremely helpful and easy to understand. I followed this one and managed to apply it to my data, I was hoping to have the script apply to ‘open as app’ so I could use it as a front end to take product orders but it did not work. Any advice on how this dependent drop down can be applied in a more user friendly front end? Thanks

Super lesson, thank you, I will try to do this 👍🙏

Thank you for the great informative Vedios .You need to update this method because i managed to create multi levels drop-down list using query and filter with transpose function it was very easy

Thank you :)

Thank you a lot for the video. I just couldn't figure out how I would apply it to two or more sheets.

Would it be possible to duplicate Column (A, B, C) dependent drop down list to Column (D, E, F) and so on with the same dependent drop down list?

THANK YOU SO MUCH

This is great! Do you also know if there is a way to create a project list where you enter in a start date or series of dates and it fills in another cell with color in a calendar view?

Awsome...yr "the guy"...

if I have lest more than 500 option how I can store them in the array or if there is any other way i can use

I learned a lot today :))

Man, you're the fucking master.

Cool!

Amazing Video! I built this exactly how you demonstrated in the video. I am hoping someone out there can help me apply this script to other tabs within the same file.

Hi! Thank you so much for taking the time to make this video. I'm having a little bit of trouble at 31:15 where your filters apply into master. The main difference between your master and mine is that your drop down options are located in the rows(2+) and columns(1-3) as options. For me, my options are in the columns(1-3) but for my master, I want the drop downs to appear from E4 to G13. I cant seem to figure out how to get it to that location. I'm not sure if my explanation makes sense, if you need clarification, please ask. Thanks For example, yours says var cell = ws.getRange("C4"); but mine says var cell = ws.getRange("G4"); and yours says if(wsName == "master" && c === 1 && r >1) mine says if(wsName == "master" && c === 5 && r > 3)

Ok is there a way to get the 2nd row with the dropdown validations to show up and change if my 1st column is auto populating based on a filtered list from another sheet instead of from a dropdown in the 1st column? Originally I had issues because my 1st row was populating based on HLOOKUP formulas in the cells, but the script acted as if the cell never changed so the script wasn't working correctly ( I assume because the script could "see" the formula in the cell and it never changed). Now I noticed that the script only recognizes a change is a row where the "paste" started and all the rows below it are not recognized by the script.

Genius!!

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

what will be the code addition if we need to add last value insert into the validation cell ... in your example when region is selected its auto fill the state instead of selection

Assume my options sheet has the headings as columns instead of rows, how do i filter the options array such that i get all the headings because o[0] obviously won't work, that's the first column, how to i get the first row

great😍

Hi! this video, along with your other videos is so useful! Was able to use it for our inventory. But how can I apply the script to 2 tabs in the same workbook? I was able to apply it in the tab where I input all the "ins" of my inventory, but just wanna know how to also apply it to the "outs" tab of my inventory?

This tutorial is awesome! Even though I was not using AppScirpt ever before, I was able to apply it to my own needs. I just have one question: is there a possibility that we can automatically set formatting for the dependent drop-down list? For instance, having a "Chip" style instead "Arrow" style and adding colours for different options on the list?

Hello, what if one of my column is date, so how can i format date to "dd.mm.yyyy" in script when filter?

Hello sir... Great video 👍👍🙏🙏

Thank you so much! 31:03

Another useful video! Thanks @Learn Google Spreadsheets! What if I want to use the code for many sheets?

What changes I should make it in script to make it 4 step

You're a wizard !

i need some help with multiple level dependent drop down. is there any way to ask you?

Hello, do you have any advice how could I set the second dropdown list to be Distinct values? In other words, how can I remove a used item from the drop-down list if the item was already selected in the column? Thank you

is there any formula to identify sloping upward or downard share prices unlike to filter flat moving share prices images from many number of share price sparkling images

hello, ty so much for this video, it is part of a solution i been looking for, i was wondering how ever is it possible to use a checkbox instead to create a follow up data validation, like the one on the video, but with the condition if, check box is checked, first column options appear, and if unchecked box it removes the drop down validation? i have been looking into this and haven;t found anything that could help me, on how to write a scrip to be dependent on a checkbox true/false