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!
@DataDashPro
8 ай бұрын
Glad it help to you. Please subscribe channel for more video as well
@moazzumgillani4852
2 ай бұрын
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!
@SantoshBudakoti
2 ай бұрын
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
@DataDashPro
2 ай бұрын
Glad it's help. Any other related questions or problem please write me to develop solution accordingly
@manolopantanetti1726
4 ай бұрын
Thank you, i was frustrated until i come up with your video! Keep doing theese tutorials!🥰
@Hadzo88
15 күн бұрын
Yes, finally with a good explanation how to do this. You have my thanks!!!! And my Like and a sub!
@shubhamsutar2
4 ай бұрын
I was crazily searching this type of trick. You are a Life Saver!!!
@DataDashPro
4 ай бұрын
glad its help.
@ExceABC
Сағат бұрын
You are just Amazing
@feriiboo
20 күн бұрын
Thank you so much for this video, I am already using it
@arundhathil1233
29 күн бұрын
Thank you very much buddy! For this crystal clear solution✨✨
@ZeeshanFarooq-fq3xs
3 ай бұрын
Best Video explaining everything in detail. Thank You !!!!
@DataDashPro
3 ай бұрын
Thank you soo much
@sanudotcom3
28 күн бұрын
You are genius 🙂 മിടുക്കൻ
@tahsinboos3409
7 ай бұрын
It’s called a pro! 👍 💥
@spideraccessadmin
19 күн бұрын
This video helped me , Thanks
@haroonahamed1673
4 ай бұрын
No words…. Great one buddy,
@MrJdorrington
4 ай бұрын
Fabulous. Thanks. Great to avoid apps scripts!!
@AndrewPatterson-fj6ln
3 ай бұрын
Great video - thank you!
@Mae-DG
2 ай бұрын
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. 😊
@DataDashPro
2 ай бұрын
Glad it was helpful!
@DataDashPro
2 ай бұрын
kzitem.info/news/bejne/zamFqWpnnF-VqW0 have a look to this concept. its might be helpfull.
@DataDashPro
2 ай бұрын
working on this issue since many people facing this problem.
@alexanderbauzon4775
Ай бұрын
thanks for this video
@user-qq8iz1zv7h
2 ай бұрын
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
@DataDashPro
2 ай бұрын
You can simply reference it. It will still work
@viltontech
4 ай бұрын
Thanks, amazing solution. I tried using App Script code, but final result is slow, and kind of complex to implement
@DataDashPro
4 ай бұрын
Any things else in mind ask me about it to develop new video.
@almiahkayedequito1823
Ай бұрын
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.
@DataDashPro
Ай бұрын
HI, i have cover this issue in my new video. Please take a look to those in same playlist.
@OGTFoundation
16 күн бұрын
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?
@DataDashPro
15 күн бұрын
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
@DataDashPro
15 күн бұрын
kzitem.info/news/bejne/mYKO0ZeohHOJnIo
@DataDashPro
15 күн бұрын
or follow this method. kzitem.info/news/bejne/pZtmu6KEn36IqX4
@DataDashPro
15 күн бұрын
if multiple tab then this will also work much better.
@JannatulBakiSaifa
3 ай бұрын
Thank you
@DaniilBohatyr
6 ай бұрын
saved my day!
@DataDashPro
6 ай бұрын
new video is comming with unique new concept.
@marchantrodolfo
Ай бұрын
The best
@hriepma
6 ай бұрын
Great video!!! 🥳
@prahadimeidyswara4630
2 ай бұрын
amazing video..great and thankyou very much🎉🎉🎉
@DataDashPro
2 ай бұрын
Most welcome 😊
@muhammadayub9489
2 ай бұрын
thank youuuuuuu
@eugenek199
2 ай бұрын
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?
@DataDashPro
2 ай бұрын
Please watch my second method. With that you don't need to worries about the deletion or addition of rows
@Mae-DG
2 ай бұрын
@@DataDashProwhat is the title of the video for the second method?
@DataDashPro
2 ай бұрын
@@Mae-DG here is the link kzitem.info/news/bejne/zamFqWpnnF-VqW0
@Mae-DG
2 ай бұрын
@@DataDashPro thank you. ☺️
@nabilahabdullah1591
6 ай бұрын
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?
@DataDashPro
6 ай бұрын
I will review it soon and try to answer or make a new video
@lucarnicelli
2 ай бұрын
any updates?
@josphinepriyanka8815
Ай бұрын
How to apply color to the selected dropdown values.
@DataDashPro
Ай бұрын
Hi simply apply conditional formatting
@josphinepriyanka8147
Ай бұрын
Thank you it's working..
@ferinaadrian4273
7 ай бұрын
the formula results do not appear after I enter the formula byrow & lambda(x ... is there a solution?
@DataDashPro
7 ай бұрын
It will work since I used the same formula. Make sure there are matches found
@DataDashPro
7 ай бұрын
Still not working then send me screen shot and I will explain or send me sheet link
@ferinaadrian4273
7 ай бұрын
This works already, thank you so much man! Apparently because my spreadsheet needs time to process my large amount of data.
@ferinaadrian4273
7 ай бұрын
This is a very good formula for dependent drop down list so far, thank you so much !!
@tahsinboos3409
7 ай бұрын
Is there anyway to use 2nd & 3rd level not only one sheet but also every sheet which I want?
@DataDashPro
7 ай бұрын
you can do the same and create sheet.
@tahsinboos3409
7 ай бұрын
@@DataDashPro tnx
@DataDashPro
7 ай бұрын
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
@tahsinboos3409
7 ай бұрын
@@DataDashPro that's called life saving comment! ❤️ thank you so much sir.
@DataDashPro
7 ай бұрын
I think this new video will help and solve your problem. kzitem.info/news/bejne/zamFqWpnnF-VqW0
@gokufujison
2 ай бұрын
is it possible without the intermediate sheets? I need to use the same nested dropdown liast for multiple sheets in a workbook
@DataDashPro
2 ай бұрын
Then you need to watch this video and apply this concept. this use no extra helper column but a little scripts.
@DataDashPro
2 ай бұрын
kzitem.info/news/bejne/0qN9t5iLpJdlimk
@kctinternet
6 ай бұрын
thank you
@DataDashPro
6 ай бұрын
Thank you
@CuriousDerek
3 ай бұрын
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
3 ай бұрын
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.
@CuriousDerek
3 ай бұрын
@@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 KZitem 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 KZitem SEO a lot, please let me know if you ever wanna bounce around some ideas. Your tutorials are gonna change lives broski 🙏🏼🙏🏼🙏🏼
@DataDashPro
3 ай бұрын
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.kzitem.info/news/bejne/0qN9t5iLpJdlimk
@DataDashPro
3 ай бұрын
Regarding SEO, I will please to take your experince as well. consider the same video.kzitem.info/news/bejne/0qN9t5iLpJdlimk 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
@user-we5nf2lb9c
7 ай бұрын
THIS FORMUL IS WORKING BUT THERE IS ONE PROBLEM IF I SELECT SAME DROPDOWM MORE THAN ONE TIMES ITS DEPENDENT DROPDOWN CHANGES
@DataDashPro
7 ай бұрын
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.
@user-we5nf2lb9c
7 ай бұрын
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
@user-we5nf2lb9c
7 ай бұрын
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
@muhammedshibilik8191
3 ай бұрын
I can't get the file through the link which you are given
@DataDashPro
3 ай бұрын
I think I shared the file
7 ай бұрын
how can you make the drodown list work with 12 different sheets assuming they are months?
@DataDashPro
7 ай бұрын
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 .
@DataDashPro
7 ай бұрын
Understand the Question and in upcomming serie will explain this soon. Don't forgot to subscribe the channel. Thank you.
@DataDashPro
7 ай бұрын
I think this new video will help and solve your problem. kzitem.info/news/bejne/zamFqWpnnF-VqW0
@niranjanself7453
7 ай бұрын
Explanation is not at all clear. Detailed step by step explanation is required please.
@DataDashPro
7 ай бұрын
Please watch it again and if you face a problem in steps i will explain it.
Пікірлер: 88