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
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.
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
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
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?
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?
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
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!
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?
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 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!
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, 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.
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
Way easier than all of the craziness of writing scripts. Thank you.
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!
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
Excelente!! La mejor explicación que he encontrado. No hablo ingles, pero siguiendo las imagenes por fin me resultó !!!😀
Saw many videos, but you explained it as I wanted. Out of Box thinking.. Thanks!
Thank you for producing Hash! Clear and easy to follow.
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!
This has been very helpful! Thank you for making this video!
This is exactly what I was looking for 💯
hi there! any chance you have a copy of the file you made?
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?
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
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?
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!
and another superb tutorial - wish I were 50+ years younger and in one of your classes...
Thank you very much .😊
Thaanh you very much!
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?
Give this a shot: ua-cam.com/video/c8hU9IuS0VA/v-deo.htmlsi=36G1TkGajq3ZDnwn
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!
Hi!!! do you think you could help me out?
My data is put differently compared to yours and im getting the wrong stuff shown.
Hi! The structure for this kind of dependent dropdown list really needs to be setup in this way otherwise it won't work.
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.
Thank you so much! you are the real deal!!
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!
Thanks!🥰
That is genius!!
Thanks!
is there any other video upcoming you're gone😢
great
GOAT 🐐
Valeu! 🤩
you're problem solver!!
That's the kind of recognition I truly appreciate. Thanks gianluca