Infinite Multiple Dependent Dropdown Lists In Google Sheets

Рет қаралды 34,053

Күн бұрын

Пікірлер: 56

@boz_ley 4 ай бұрын

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

@HashAliNZ 4 ай бұрын

Nice lambda

@trekinn_nepal Ай бұрын

that is for second level. what about the third level dropdown?? how to check column A and B and get dropdown in C?

@jpereira97 3 күн бұрын

This lose the dynamic, case rows removing or insert at tables with the dropdowns lists

@NunyaBiznasNML 2 ай бұрын

Way easier than all of the craziness of writing scripts. Thank you.

@MsPenguinQueen 2 ай бұрын

Thank you, I have watched a few videos promising to show dependent drop downs and then they give only one and you can't do others, or you have to go into each dropdown you make, it was more work than creating my Data info. Yours is simple and straight to the point. My data is now easy to put into my dropdowns. Thank you again.

@HashAliNZ 2 ай бұрын

I'm glad you finally found a solution that works for you, Penguin. I've got two other videos on dependent dropdowns in case you need alternative options, but if this one works for you then that's brilliant

@Farouk-voiceover Ай бұрын

Thanks from the bottom of my heart! man, u def deserve a sub :)

@ChristianDellon 5 ай бұрын

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?

@marenlibrarian 5 ай бұрын

I have the exact same question!

@andrefri78 6 ай бұрын

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

@sandlapparels3753 6 ай бұрын

Saw many videos, but you explained it as I wanted. Out of Box thinking.. Thanks!

@pablolillo3872 4 ай бұрын

Excelente!! La mejor explicación que he encontrado. No hablo ingles, pero siguiendo las imagenes por fin me resultó !!!😀

@Denzarki 6 ай бұрын

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

@HashAliNZ 6 ай бұрын

Love it!

@manamedia 4 ай бұрын

Thank you for producing Hash! Clear and easy to follow.

@gothamfury 4 ай бұрын

This has been very helpful! Thank you for making this video!

@hobojoesnr.3283 4 ай бұрын

hi there! any chance you have a copy of the file you made?

@nothing13308 4 ай бұрын

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?

@donkasaurus 19 күн бұрын

How can I make a copy of the spreadsheet without breaking the formulas - been struggling with that for a while - HELP!

@nlc5344 5 күн бұрын

How do you prevent users from breaking the dependent dropdowns?

@cowboykaro 2 ай бұрын

thanks for this! though I have encountered a problem. Whichever row a possible entry ends in on the master data list, means I can't select that option in a later row in the dropdown section. For example, I am logging where my mom keeps her DVDs by room, then shelving unit, then shelf number, etc. There are only 2 rooms, so I can no longer have the 'Bedroom' entry in the dropdown sheet after row 12, because that is where all the possible locations for shelves in the Bedroom end in the master list. Then, I can't add a specific shelving unit after row 8 because there aren't any more options for that unit in the master list, and so on so forth for each dropdown column. Any way around this?

@HashAliNZ 2 ай бұрын

Well that's a unique problem I haven't encountered before and shouldn't be happening from the method I've shown in this video. Can you share your spreadsheet for me to have a look at how it's structured and the formulas you're using? You can share to themathlabnz@gmail.com and I'll take a look

@AaronPeter-be8ce 8 ай бұрын

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!

@HashAliNZ 8 ай бұрын

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.

@AaronPeter-be8ce 8 ай бұрын

@@HashAliNZ that's what I feared. Thank you very much for the quick reply!

@lilsaintnik 8 ай бұрын

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!

@andrefri78 6 ай бұрын

Valeu! 🤩

@Ayana-u9k Ай бұрын

Mine doesn't work when I try to drag it down in the DD1 tab

@ninortayaro 2 ай бұрын

Hi!!! do you think you could help me out? My data is put differently compared to yours and im getting the wrong stuff shown.

@HashAliNZ 2 ай бұрын

Hi! The structure for this kind of dependent dropdown list really needs to be setup in this way otherwise it won't work.

@soizic97 3 ай бұрын

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?

@HashAliNZ 2 ай бұрын

Give this a shot: kzbin.info/www/bejne/mWnLhmx_qrhjjKMsi=36G1TkGajq3ZDnwn

@MuhamadZulAimanZahidiMATTARY Ай бұрын

how to do the same thing but to other sheets not other file the same file

@Piston101 Ай бұрын

Thanks budy, you are awsome.

@TilakConrad 9 ай бұрын

and another superb tutorial - wish I were 50+ years younger and in one of your classes...

@nithieskannasivaraj4684 8 ай бұрын

This is exactly what I was looking for 💯

@FireflyFanatic3 3 ай бұрын

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

@HashAliNZ 3 ай бұрын

There are two ways: conditional formatting, and scripting. Unfortunately it can't be don't with Dropdown chips as far as I can tell.

@FireflyFanatic3 3 ай бұрын

@@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!