Good News: Using Google Sheets Table we can Easily Create Multi Level dependent dropdown, Insert & Delete rows and it will still work. Don't wait watch my new video : ua-cam.com/video/nD3_BbY5BCI/v-deo.html
This is amazing! It absolutely solves my need to get dependent dropdown list for each row without having formula in each and every row. Thank you so much!
Man you are a legend! what a perfect method, to be honest. There are some guys out there who are doing scripts for this. You nailed it with a much simpler strategy, cool!
Hi dash I hope you are well, I need help when I do the transpose I have a lot of categories, and the quantity of columns are not enough for example I have almost 300 categories, How do I do that? theres another way to do this? I just want second level
@@DataDashPro thanks for the answer I'd found the solution. I just add more columns to the right. like 600 cells, and it works for me, the issue was because i was no able to make transpose because the limits of columns.
hi @DataDash Pro, is there any way to add those dropdown lists to multiple columns in the same sheet? I tried to copy paste and drag and drop but nothing works, do you have a formula for me or something else?
Hi, if I add new row at Drop down list sheet, the drop down in column D shows an error "Invalid: Input must fall within specified range". If I delete a certain row in Drop down list sheet, it shows the same error at the botton of the column D.
Thank you so much for this video. This is what I needed and looking for! Please continue making and sharing helpful and easy to follow videos like this. ☺️♥️ 1 question, if I insert new row, the formula doesn’t apply to the new row. I’ve read in the comments section that you have second method video but I can’t seem to find it. Can you share the link or the video title please. 😊
Could you help me with the following issue? I apply a method with three levels: level 1 is Destination, level 2 is Start Date, and level 3 is End Date. The problem arises at level 3 because multiple destinations can share the same start dates but have different and similar end dates. As a result, I see end dates that are not possible for the specific destination and start date combination. How could I resolve this?
@DataDashPro I have the exact same issue! In my sheets level 1 is Item Category, level 2 is Item Manufacturer and level 3 is Item Model. Multiple Categories can have the same Manufacturer so my level 3 shows all of the choices from one Manufacturer without considering the category! Was this resolved for you? Was it a simple change?
thank you so much for this. i've a follow up question to this. what if end-users start inserting new rows in the 1st level sheet. this messes up the drop down reference to the 2nd and 3rd level sheets. is there a fix for this?
Thank you so much for sharing this video 🙏🙏 I am finding this since last 3-4 months. I have watch lots of videos but no one tell about that. Once again thank you
but what if I need to make those dropdowns in the same collumn, but in different rows? Where some of the rows will be dropdowns, others will be something else. Also it must be "drag downn" to reapeat those mini tables
For this you need to follow my second video method as they will work without error or even I uploaded a new video few days ago that will also work much better
The problem is when you add a new row in the Dropdown list, the Data Validation gets split so you have to manually reset the Data Validation. Is there any way you can show to automate it through scripting?
I tried to do this with my own data and for some odd reason the 3rd level filter shows everything under the first level. For example, I changed the “Continent” to “Companies,”, “Country” to “Product Categories,” and “City” to “Products.” In the dropdown, I’d set the validation to Compaines from table. Followed the steps for 2nd level, it works. I’d select a company, and only the product categories within that company showed up. But then once I get to the third level, all products show up within a product category, from all companies. Not sure where I messed up. I tried to use your sheet and put in my own data, same thing happened. Any help would be greatly appreciated 🙏🏼🙏🏼🙏🏼
@@DataDashPro Dude you’re absolutely too generous! I ended up asking ChatGPT for help and it switched up the formulas to make it work. But also, I just went through your channel and found updated videos, so tomorrow I’m going try again, following your new video. If it still doesn’t work, I’ll pop into the new video and leave a comment so that you get more engagements on new videos. Your UA-cam channel reminds me of a legend that I watched years ago and he was teaching Photoshop. When I found his channel, he had like 1000 subscribers. Today, I’m almost certain he’s well past a million. Keep going! Your teaching style is much easier to follow and you’re one of the only channels with updated content in 2024. I nerd out over UA-cam SEO a lot, please let me know if you ever wanna bounce around some ideas. Your tutorials are gonna change lives broski 🙏🏼🙏🏼🙏🏼
Thank you for support. Yeas i develop new video and i am still searching for good ways to make dropdown easy for the users.Here is the link of new video.ua-cam.com/video/qmGQdUke4W4/v-deo.html
Regarding SEO, I will please to take your experince as well. consider the same video.ua-cam.com/video/qmGQdUke4W4/v-deo.html topic is much better but view are still very less as compared to my other video. do you have any idea or can you just try and give me updated description and tittle? Thank you
Thank you. I had a dropdown for income and expense codes and often chose an expense code where I needed an income code. If I may respectfully request, could you show the formulas again after entering them? I had a little difficulty pausing to copy them as I followed along.
thank you for this video. i have a question: if i delete a row, the data shifts up but the data validation becomes empty and i have to copy the data validation to that cell again. any way to keep the data as is even when rows are being deleted?
I think you mean same Did you mean, same dropdown feature on 12 different sheets? if so than you can simply make duplicate copy of sheet and on new sheet feature will be same@@tahsinboos3409
okay! supoose if i am selecting fruit in the first cell then vegetable in second cell for this dropdown is working fine but as soon as i choose fruits again in the third cell it is knot showing me the dropdown of fruit hope my problem is clear to you@@DataDashPro
suppose i have three list of item fruit vegetable dryfruits if i choose fruit in first cell vegetable in second cell than it is working fine but if i select fuit again in third cell it is not working its is showing wrong dropdown @@DataDashPro
Did you mean, same dropdown feature on 12 different sheets? if so than you can simply make duplicate copy of sheet and on new sheet feature will be same .
Good News: Using Google Sheets Table we can Easily Create Multi Level dependent dropdown, Insert & Delete rows and it will still work. Don't wait watch my new video : ua-cam.com/video/nD3_BbY5BCI/v-deo.html
I have gone through sooo many videos to execute this functionality and nothing worked until I found this video. Thank you soooo much!
Glad its work for you.
Excellent functionality and you explained it so clearly that my grandma could figure this out. Thank you!
This is amazing! It absolutely solves my need to get dependent dropdown list for each row without having formula in each and every row. Thank you so much!
Glad it help to you. Please subscribe channel for more video as well
Man, you are life-saver. 5 hours, and that masterpiece have solved everything.
Glad you like it
Glad you like it
Thanks really helpful for the guide 👍
Man you are a legend! what a perfect method, to be honest. There are some guys out there who are doing scripts for this. You nailed it with a much simpler strategy, cool!
Obrigado!
Era isso que eu precisava e com certeza não iria conseguir sozinho!
I was crazily searching this type of trick. You are a Life Saver!!!
glad its help.
Hi dash I hope you are well, I need help when I do the transpose I have a lot of categories, and the quantity of columns are not enough for example I have almost 300 categories, How do I do that? theres another way to do this? I just want second level
Is it possible to share a sample sheet link to review it and then suggest best method
@@DataDashPro thanks for the answer I'd found the solution. I just add more columns to the right. like 600 cells, and it works for me, the issue was because i was no able to make transpose because the limits of columns.
@@alvarorodriguez1428 that's greate. if you want to optimize it further i am happy to see your sheet.
Anyway you can think of to do this, but still be able to sort and apply filters to your sheet?
Let me think about it
This really works, thanks..
hi @DataDash Pro, is there any way to add those dropdown lists to multiple columns in the same sheet? I tried to copy paste and drag and drop but nothing works, do you have a formula for me or something else?
My this video might help you as in this can simply write data comma separted.
@@DataDashPro sorry, did u add a link or something bcs i am not able to see it
@@RaresCordoneanu-n5d ua-cam.com/video/31ritcQ4t2o/v-deo.html
Thank you, i was frustrated until i come up with your video! Keep doing theese tutorials!🥰
Hi, if I add new row at Drop down list sheet, the drop down in column D shows an error "Invalid:
Input must fall within specified range". If I delete a certain row in Drop down list sheet, it shows the same error at the botton of the column D.
HI, i have cover this issue in my new video. Please take a look to those in same playlist.
Thank you so much for this video. This is what I needed and looking for! Please continue making and sharing helpful and easy to follow videos like this. ☺️♥️
1 question, if I insert new row, the formula doesn’t apply to the new row. I’ve read in the comments section that you have second method video but I can’t seem to find it. Can you share the link or the video title please. 😊
Glad it was helpful!
ua-cam.com/video/lsOC61c-dv8/v-deo.html have a look to this concept. its might be helpfull.
working on this issue since many people facing this problem.
Yes, finally with a good explanation how to do this. You have my thanks!!!! And my Like and a sub!
Thank you very much buddy! For this crystal clear solution✨✨
Could you help me with the following issue? I apply a method with three levels: level 1 is Destination, level 2 is Start Date, and level 3 is End Date. The problem arises at level 3 because multiple destinations can share the same start dates but have different and similar end dates. As a result, I see end dates that are not possible for the specific destination and start date combination. How could I resolve this?
Would you like to share the sheet. you can connect on linkedin to discuss. www.linkedin.com/in/freelancer-engineer/
@DataDashPro I have the exact same issue! In my sheets level 1 is Item Category, level 2 is Item Manufacturer and level 3 is Item Model. Multiple Categories can have the same Manufacturer so my level 3 shows all of the choices from one Manufacturer without considering the category!
Was this resolved for you? Was it a simple change?
@@ProductionNinjaCat can you at least share the sample of sheet so i can reivew it. i hope this will be small changes.
thank you so much for this. i've a follow up question to this. what if end-users start inserting new rows in the 1st level sheet. this messes up the drop down reference to the 2nd and 3rd level sheets. is there a fix for this?
Please watch my second method. With that you don't need to worries about the deletion or addition of rows
@@DataDashProwhat is the title of the video for the second method?
@@Mae-DG here is the link ua-cam.com/video/lsOC61c-dv8/v-deo.html
@@DataDashPro thank you. ☺️
You are just Amazing
Best Video explaining everything in detail. Thank You !!!!
Thank you soo much
Thank you so much for sharing this video 🙏🙏 I am finding this since last 3-4 months. I have watch lots of videos but no one tell about that. Once again thank you
Glad it's help. Any other related questions or problem please write me to develop solution accordingly
but what if I need to make those dropdowns in the same collumn, but in different rows? Where some of the rows will be dropdowns, others will be something else. Also it must be "drag downn" to reapeat those mini tables
You can simply reference it. It will still work
omg u helped me a lot, thank you so much for this straightforward video!!
This is great, thank you, but if I sort the table, validations break. Is there a solution for when you need to actively work with a table and sort it?
For this you need to follow my second video method as they will work without error or even I uploaded a new video few days ago that will also work much better
ua-cam.com/video/8LXkcrKAXiU/v-deo.html
or follow this method. ua-cam.com/video/De0UnNfLWvI/v-deo.html
if multiple tab then this will also work much better.
Thanku so much sir ❤
The problem is when you add a new row in the Dropdown list, the Data Validation gets split so you have to manually reset the Data Validation. Is there any way you can show to automate it through scripting?
have a look to my Multi Sheet method in same playlist where i explain new method , so you never face problem with deleting or adding
I tried to do this with my own data and for some odd reason the 3rd level filter shows everything under the first level.
For example,
I changed the “Continent” to “Companies,”, “Country” to “Product Categories,” and “City” to “Products.”
In the dropdown, I’d set the validation to Compaines from table. Followed the steps for 2nd level, it works. I’d select a company, and only the product categories within that company showed up.
But then once I get to the third level, all products show up within a product category, from all companies.
Not sure where I messed up.
I tried to use your sheet and put in my own data, same thing happened.
Any help would be greatly appreciated 🙏🏼🙏🏼🙏🏼
would you like to share your sheet or just make a copy and share it. I will work on that my self and let you about your problem.
@@DataDashPro Dude you’re absolutely too generous! I ended up asking ChatGPT for help and it switched up the formulas to make it work.
But also, I just went through your channel and found updated videos, so tomorrow I’m going try again, following your new video. If it still doesn’t work, I’ll pop into the new video and leave a comment so that you get more engagements on new videos.
Your UA-cam channel reminds me of a legend that I watched years ago and he was teaching Photoshop. When I found his channel, he had like 1000 subscribers. Today, I’m almost certain he’s well past a million.
Keep going! Your teaching style is much easier to follow and you’re one of the only channels with updated content in 2024.
I nerd out over UA-cam SEO a lot, please let me know if you ever wanna bounce around some ideas.
Your tutorials are gonna change lives broski 🙏🏼🙏🏼🙏🏼
Thank you for support. Yeas i develop new video and i am still searching for good ways to make dropdown easy for the users.Here is the link of new video.ua-cam.com/video/qmGQdUke4W4/v-deo.html
Regarding SEO, I will please to take your experince as well. consider the same video.ua-cam.com/video/qmGQdUke4W4/v-deo.html topic is much better but view are still very less as compared to my other video. do you have any idea or can you just try and give me updated description and tittle? Thank you
Thank you. I had a dropdown for income and expense codes and often chose an expense code where I needed an income code. If I may respectfully request, could you show the formulas again after entering them? I had a little difficulty pausing to copy them as I followed along.
Hi for personal assistance contact me through linkedin. www.linkedin.com/in/freelancer-engineer/
It’s called a pro! 👍 💥
Thank you so much for this video, I am already using it
very helpful, thanks!
Good content. Thank you.
Definitely the best dropdow technique for GS
thank you for this video. i have a question: if i delete a row, the data shifts up but the data validation becomes empty and i have to copy the data validation to that cell again. any way to keep the data as is even when rows are being deleted?
I will review it soon and try to answer or make a new video
any updates?
the formula results do not appear after I enter the formula byrow & lambda(x ... is there a solution?
It will work since I used the same formula. Make sure there are matches found
Still not working then send me screen shot and I will explain or send me sheet link
This works already, thank you so much man!
Apparently because my spreadsheet needs time to process my large amount of data.
This is a very good formula for dependent drop down list so far, thank you so much !!
is it possible without the intermediate sheets? I need to use the same nested dropdown liast for multiple sheets in a workbook
Then you need to watch this video and apply this concept. this use no extra helper column but a little scripts.
ua-cam.com/video/qmGQdUke4W4/v-deo.html
You are genius 🙂 മിടുക്കൻ
This video helped me , Thanks
Is there anyway to use 2nd & 3rd level not only one sheet but also every sheet which I want?
you can do the same and create sheet.
@@DataDashPro tnx
I think you mean same Did you mean, same dropdown feature on 12 different sheets? if so than you can simply make duplicate copy of sheet and on new sheet feature will be same@@tahsinboos3409
@@DataDashPro that's called life saving comment! ❤️ thank you so much sir.
I think this new video will help and solve your problem. ua-cam.com/video/lsOC61c-dv8/v-deo.html
Great video!!! 🥳
saved my day!
new video is comming with unique new concept.
How to apply color to the selected dropdown values.
Hi simply apply conditional formatting
Thank you it's working..
amazing video..great and thankyou very much🎉🎉🎉
Most welcome 😊
No words…. Great one buddy,
Fabulous. Thanks. Great to avoid apps scripts!!
Thanks, amazing solution. I tried using App Script code, but final result is slow, and kind of complex to implement
Any things else in mind ask me about it to develop new video.
Great video - thank you!
thanks for this video
THIS FORMUL IS WORKING BUT THERE IS ONE PROBLEM IF I SELECT SAME DROPDOWM MORE THAN ONE TIMES ITS DEPENDENT DROPDOWN CHANGES
what is mean by selecting more then once. In same cell or where you select more then once. if you share a little more details i can help better.
okay! supoose if i am selecting fruit in the first cell then vegetable in second cell for this dropdown is working fine but as soon as i choose fruits again in the third cell it is knot showing me the dropdown of fruit
hope my problem is clear to you@@DataDashPro
suppose i have three list of item fruit vegetable dryfruits if i choose fruit in first cell vegetable in second cell than it is working fine but if i select fuit again in third cell it is not working its is showing wrong dropdown
@@DataDashPro
how this can apply to multiple sheets? because i tried and fail miserable
Hi, Please follow my second video method. this will solve issue. ua-cam.com/video/lsOC61c-dv8/v-deo.html
Thanks.
You're welcome
how can you make the drodown list work with 12 different sheets assuming they are months?
Did you mean, same dropdown feature on 12 different sheets? if so than you can simply make duplicate copy of sheet and on new sheet feature will be same .
Understand the Question and in upcomming serie will explain this soon. Don't forgot to subscribe the channel.
Thank you.
I think this new video will help and solve your problem. ua-cam.com/video/lsOC61c-dv8/v-deo.html
I can't get the file through the link which you are given
I think I shared the file
could you make video for how to do same in excel
Okay sure. Soon make it
@@DataDashPro thank you so much
Thank you
The best
thank you
Thank you
thank youuuuuuu
idk why it's not working for me
watch this new concept its much better to apply. ua-cam.com/video/nD3_BbY5BCI/v-deo.html
when i applied same formula it didnot work, then i have copied from your sheet started working , hahhaha
You need to pay attention to each and everything. Glad my sheet help you
Explanation is not at all clear. Detailed step by step explanation is required please.
Please watch it again and if you face a problem in steps i will explain it.
Thank you