How To Create ENDLESS Dependent Drop-Down Lists in Google Sheets For Every Row

Показать описание

In this video, I'm going to show you how to create infinite dependent drop-down lists in Google Sheets. This is a fantastic method to swiftly navigate through data rows, enhancing your efficiency and making the most of Google Sheets' robust features. Whether you're a seasoned user or just starting with Google Sheets, this video will open new doors to data management. Watch now and let's grow together!

----------------------------------------------------------------------------------------------------
⏳ TIMESTAMPS
----------------------------------------------------------------------------------------------------
0:00 Intro
0:37 The Traditional Way
9:20 The Other (Better) Method

----------------------------------------------------------------------------------------------------

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

Рекомендации по теме

Комментарии

You guy is amazing. I have been searching for this one long since, and most of the videos are giving partial solutions. Your ones have a complete package. Thanks a lot

mdhafizhasan

Dude. You saved my bacon. Just organised my school's swimming carnival. Easiest video to follow along with by far. Thanks for all the hard work you've put in.

hwycufl

I took on something much more complicated than I initially thought as an amateur, and you made it work amazingly for me. I will be constantly adding to the sheet I was working on to make it better, but this was an amazing start. Thank you so very much.

psiklone

You're the best person to use an define humanitarian, for making a course like this free.
thanks Boss.
Watching from Nigeria.

okon

I have watched so many videos and yours is the only one that made sense to me. Thank you so much!!!

hollydurfee

Thank you. I've been trying to do this for several hours and tried several tutorials but yours is the only one that has worked.

BRBbass

This was truly amazing! This brought my spreadsheet to another level.😀

johankallum

this is an amazing video and very helpful. in your video you populated only 2nd row, how about the suceeding row? what is Query script for the 2nd and suceeding row?

joelencina

Amazing, I love your instructions, very clear.

vivienneandrews

This is soo cool. Thank you. Subscribed!

onjadar

i've tried to do this for hours thanks for this video ! not all heroes wear capes !

nicolaspolsterer

Nice one. A small improvement in query function could be, instead of selecting one column at a time and nameing them 'drop down 1', 'drop down 2' etc, just select all like this "select * where .... " or select what you need "select A, D, G, H ... where ... " then just select new resultant column and map this range to next dropdown.

Plus I picked up couple of productivity tips a) instead of freezing the row from menu, just drag thick border under row 1 to where you want to freeze b) instead of adding dropdown down from menu or right click just type @ drop

SalmanSadiq

The second part of the video is a magical thing only you know Hash, AWESOME WORK!

TheKayShawn

This is super helpful. Thank you for sharing this.

afiesty

Hello, I made a dropdown list dependent on another one. However, when I change the value of the first list, the selection in my second list stays on my old selection. How to solve this problem and make the second list automatically update or delete itself when the value of the first list is changed? I see that an invalid message appears in yours, how to display the invalidity?

c.parizeault

Nice content, subscribed. I have some questions not sure you could help, is out of topic. I want to sum to value below cell but I want it to stop when it detected the empty cell and done sum up the value below the empty cell.

yasufumithebest

Thank you for this amazing explanation and video! :)

KayHurricane

This was so helpful and so easy. Thank you!

alinajenon

wow ... the 1:00 time stamp is GOLD ... binge watching your videos on google sheets

Trade-Intuition

Thank you so much for this. I had spent hours trying yo get it done in Excel😅. Do you know if there is a way to clear the values whenever you select a different item from the drop down list? Instead of having to do it manually. I would appreciate any feedback. Thank you again!❤

pameladuran

How To Create ENDLESS Dependent Drop-Down Lists in Google Sheets For Every Row

How To Create ENDLESS Dependent Drop-Down Lists in Google Sheets For Every Row

Infinite Multiple Dependent Dropdown Lists In Google Sheets

Dependent Drop Down List in Excel Tutorial

3 dependent dropdowns in Google Sheets with no code - 2023

Google Sheets - Dependent Drop Down Lists | 2 Ways

How To Create MULTIPLE Dependent Drop-Down Lists in Google Sheets

Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)

Google Sheets: How to create UNLIMITED Dependent Drop Down List || Ep - 003 || Skills Development

Create Multiple Dependent Dropdown Lists in Google Sheets

Multilevel Dependent Dropdown in Google Sheets (With Google Apps Script)

Google Sheets: Create Dependent Dropdowns with a Formula

Quickly Create Multiple Dependent Drop-Down Lists in Microsoft Excel

How to Create Multiple Dependent Drop Down Lists upto 3 levels in Excel

How to use XLOOKUP to Create Dependent Drop-Down Lists in Microsoft Excel

Google Sheets - Create Multiple Dependent Drop-Down Lists

Google Sheets - Dependent Drop Down Lists | New Method

Create Multiple Dependent Drop Down Lists in Excel (Demonstration with Example up to 3 Levels)

Create multiple dependent drop-down lists in Excel [EASY]

How to Create Multiple Dependent Drop-Down Lists in Excel | Automatically Update with New Values

Multiple Dependent Dropdown Chips in Google Sheets

Infinite Regress Of Dependent Things

How to Make a Dependent Drop Down List in Google Sheets

How to Create Multiple Dependent Drop-down Lists in Excel with Formulas

Make a dependent drop down list in Excel