Google Sheets - Dependent Drop Down Lists | 2 Ways

Leila, your video is great! Need some help - Whenever I am copy pasting the rows the data validation does not catch the filter formulas. Can you suggest me a way out.

This video helped me SO much in a worksheet I'm creating. Thank you!

Have Sheets been updated? It seems to work the same, but it does not look the same.

Can I apply this to google docs?

Doesnt work

You're a girl and you know tech?

This is great. The explanation up front about the tabular format vs report format was key and missing from all the other videos I was trying to use. Your stuff is always great, thanks!

Hi Leila! thank you so much! Whats the link to the video where you explain how to expand the dependent list?

Very nicely explained

Amazing, solved my problem. Super simple and clear to follow.

Thanks. Just what I needed.

This is genius! Thank you! 🙏

Great!

Hi Leila, I want to know if the indirect function can be used in Google Sheet. I have tried both ways to create a check list with dependent data validation. However, I am not getting the desired output. When I am pasting the same data validation in the row below, I am not getting the exact data. Through Indirect Function in Excel, we can paste down the data validation to the below rows and have the same dependent drop down list. But that is not something I am seeing in Google Sheets.

when i keep the drop down cell in other sheet and data prep formula on other the filter or index doesnt work. how we can fix this

Gosh this is complicated ngl

Thank you for video , But main issue as filter condition is =A4 is not dynamic. Because if I copy productivity / Games many times same does not work. Because we say that Filter condition . SO how =A4 change dynamically so its working fine? Pls help.

Hi Leila, I saw your video on Creating Dropdown lists in google sheets. In your video, you have shown the drop-down lists created in just two cells side by side, for example, A2 and B2. What if you want to create a series of drop-down lists across the entire column downwards. I'm trying to create an Operator Efficiency Monitoring Sheet, wherein, we have a Part Name and the drop-down dependent list I want to create is the List of Operations, that goes into making that particular Part. I have a multiple list of parts and on a daily basis, different parts are produced. So I want a matrix form of a sheet wherein every day, you select a different Part Name and its corresponding drop-down list opens. How will the Prep column behave in this case.

Thanks Leila. wonderful explation

Leila, you have a gift for clear explanations, thoughtful edits and on -screen presence. Keep up the great work!

Didn't work :(

Thanks for the tutorial. Can you please help? I created the dropdown and protected the sheet except the dropdown cell, but every time someone changes the dropdown, it affects others view, can you please help?

waste of time

I had a question suppose in the current formula made. If suppose game division had only a single value and the others have multiple values and if i want the value for game division to auto populate is there a way to do the same ?

its there a way to grey out an option once selected? and ungreyed once deleted ?

lol I follow your steps but the data validation shows different options

Thank you so much!

Exactly what I was looking for! Excellent!

you have made impressive and very helpful content on google sheets. Appreciate the videos

what if we want same lists for more than one row.

Please Google sheets have been updated so can you help with the data validation for the new updated format

how about 3 level drop downlist?

I just loving you now. really what I needed

thank you dear leila, it was so helpful

Thank you so much for this! I'm currently making my expenses tracker for 2023, and this is EXACTLY what I was looking for to categorize my expenses.

thanks , this is what I want. do you provide class for google sheet and script?

Thank you so much.. I was trying to do this using name list bcz of some certen video.. I was trying more than 3h.. You just save me

For multiple rows, You said, You're going to cover it Next Week,
Is it out yet.
Best regards from Delhi, India🇮🇳

Amazing thanks for your nice and neat tutorial. love it

Thank You!!!

Thank you so much

Great tool, what if I'm preparing a 600 line sheet? how can I do the multiple dependent lists for the 600 lines? will I create the (indirect) column 600 times?

in excel: the (indirect) function can be written in the data validation range, but in Google Sheets it is not possible

do you have an advise for that?

Helped alot! :)

That was excellent. Thankyou.

This is not correct. You can only do this for one or two cells not when you have to do it for 1000. dropdowns. You just can't repeat this activity 1000 times.

That first method doesn’t work if you want multiple drop down lists because the FILTER function will only be conditioned to that one cell.

yes, but that means you have to have a separate column for each row.
for example, A4 and B4 has a dedicated row in the H.
so if you go as low as A20:B20, then you will have to have dedicated rows for each. that's extremely limiting if you have tons of data.
there's a much better function in microsoft excel. i don't know why sheet doesn't follow suit.

Finally found a good video for this

The way of teaching incredible, but if we apply same drop down in multiple row, Showing REF error.