Infinite Multiple Dependent Dropdown Lists In Google Sheets
HTML-код
- Опубликовано: 3 окт 2024
- How to Create Multiple Dependent Dropdown Lists In Google Sheets! We start with the basics of creating a single dropdown, then dive deeper into dependent dropdowns. Complex Data Entry made easy!
After you watch these videos, just start playing in your spreadsheets. If you still want to improve, make sure you subscribe for more juicy tips and tricks.
💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓
simplify more with LAMBDA on sheet DD1 in cells A1=ArrayFormula('Dropdowns'!A2:A) and B1 =BYROW(A1:A,LAMBDA(x, TRANSPOSE( FILTER('Full List'!B2:B,'Full List'!A2:A=x)))) . Great job thanks for creating this help video. Thanks to AI lolol sharing my knowledge
Nice lambda
Thank you for producing Hash! Clear and easy to follow.
Excelente!! La mejor explicación que he encontrado. No hablo ingles, pero siguiendo las imagenes por fin me resultó !!!😀
Thankyou, making a game tracker where you pick a deck you used, which hero, which boss you fought, on what difficulty (which changes per deck) etc. and this worked perfectly :D
Love it!
Saw many videos, but you explained it as I wanted. Out of Box thinking.. Thanks!
Thank you very much!! I've used complicated scripts to do this for a long time. Now it will be very easy and useful. Congratulations
This has been very helpful! Thank you for making this video!
This is exactly what I was looking for 💯
and another superb tutorial - wish I were 50+ years younger and in one of your classes...
Thanks, very usefull and clear. It worked but then I encountered a limitation, if I add a row in the middle of other rows with information filled in, it will pick the dropdown of above, and then it doesn't work anymore. In your example, if i have 1986 selected, and then I add a row and above and under it is 1986 selected, but this new row is 1985, then the second dropdown will get stuck at 1986 dropdown. Would you have a way to fix this?
Thank you so much! you are the real deal!!
thank you so much! It must help me a lot!! could I get your datasets that you are showing on e-mail? or where can I get this samples?
hi there! any chance you have a copy of the file you made?
Question for you. I am tasked with randomly matching pairs of people from a community to have a meet up each month. I need to match these people based on multiple criteria (community level and type of business) and make sure they aren't matched again until I've exhausted the list. I can't find anything anywhere that will help me with this problem. Going to have to do it manually for now - hoping you can help!
Hi!! Quick question! After I create this sheet linked to the settings sheets, imagine I want to duplicate it. How can I maintain the link with the settings?
I have the exact same question!
Thanks!🥰
Why don't you make a library managment system for schools using QRCode and other stuff.
Definitely doable using the QR systems I've shown on this channel. The setup would be pretty much exactly the same.
Hi, do you know of a way to add checkboxes to the dropdown without having to run a script?
For example: I want to select 3 out of 10 variants in one dropdown
thank you!
Nah, not without a script. Google Sheets doesn't have a native multiple-select combobox. It is doable with a script, which I've got a video coming soon for, but if you're unable to use a script then the best option is to use checkboxes with formulas to connect them all together.
@@HashAliNZ that's what I feared. Thank you very much for the quick reply!
That is genius!!
Thanks!
Is it possible to colour-code these drop downs that are dependent on others? When I try to do so, it just reverts back to grey
There are two ways: conditional formatting, and scripting. Unfortunately it can't be don't with Dropdown chips as far as I can tell.
@@HashAliNZ okay thank you! this video was super helpful, i was at the point of tears after fighting with google sheets and chatGPT and instructional text pages from google support for hours!
Valeu! 🤩
GOAT 🐐
is there any other video upcoming you're gone😢