Multiple Dependent Dropdown Lists on Every Line In Google Sheets with Google Apps Script

Great for when you need to incorporate things like Sorting into your Google Sheet Data Table with Dropdowns, this Dependent Dropdown tutorial shows how you can use Google Apps Script to have however many lines of dependent drop-down lists you need.
----------------------------------------------------------------------------------------------------
⏳ TIMESTAMPS
----------------------------------------------------------------------------------------------------
0:00 Intro
0:17 The dataset
0:32 The setup
0:57 The goal
1:21 Writing the script
----------------------------------------------------------------------------------------------------

💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓

[TrườngPhùng-DHOE]

If I want to change the initial data fill column from Col2 to Col4 then what value should I adjust in the code you shared.

[Vish_Al_Mighty]

Your content is phenomenal. The explanation, visuals, pace, just about everything is brilliant. Subscribed in an instance!

[JOELY]

Awesome video! On my 'home' page my drop down starts in column E. How do I modify the code for that difference? I've been trying to figure it but to no avail.

[davidmojica]

Hi HashAli, Great video. Can you please share the script so that its easier to copy / paste and edit the values. Thanks!

[stefania]

Hi, this is great, thank you, but I'm getting two errors: "TypeError: Cannot read properties of undefined (reading 'source')" with
the onEdit function and "TypeError: Cannot read properties of undefined (reading 'length')" with the getNextColumnData function. Can you help?