3 dependent dropdowns in Google Sheets with no code - 2023
HTML-код
- Опубликовано: 17 апр 2023
- In this tip, we will learn how to create 3 or more dependent dropdowns without any Google Apps Script
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
Thank you so much. This was exactly what I needed, you are a life saver!
Thanks man. I was finally able to do what i wanted to do by going through your steps. Though i don't understand it completely , ill watch the video again someday again .
Very Useful ! Thanks a lot !!!
Wow! This is a great video, thank u for teaching us this.
Was looking for a way to do this and indeed learnt a lot but all those were too complicated, index match, iflen etc... This is by far the simplest that i have come across.
Thank u again🙏
that is the problem I am having too complicated for the average user
Brilliant! Thank you! Saved this video in my favorites.
Excellente! Glad that it was useful!
Muito bom! Obrigado por compartilhar!
This was so helpful! you are a life saver. :')
Thx for the kid words!
Really it's very helpful to me, I watch several video but this the best and simplest. Thanks a lot.
Thank you so much for the kind message!
Regards!
From all the videos I have watched and tried, this is the easiest and the most functional one. Very useful for work. Thanks
I'm so glad it worked!
Thanks for the kind words!
Regards,
Works like a charm! Thank you so much ❤
Thank you for commenting!
I love you. Saved my sheet for real.
Excellent!
Excellent Explanation ! Kudos from India :-)
Thank you so much!
Very helpful. Thanks!
Glad it's useful. Thanks for commenting!
thank you, perfect
Thanks, Buddy, I have used it.
Excellent!
I hope it was useful
Regards!
Thank you!
Thank you for commenting!
Thanks, it's the best tutorial😇
Thank you!
Thanks for saving me! hahahaha I did this many years ago, so I knew there was a way...
Thank you Sir! This formula helped me and it worked! But I have found that Values in the same category may change after data entry. Is it because that $ (reference) was removed in the range or do you have another idea of what I can do?
Mate, I've trying to make something similar with checkboxes to track my patient's attendance. So on two separate dropdowns, I'd like to select the patient's name and the month. And y selecting those, the attendance table would get updated and show me the records for that patient in that month. I'm two week into it already and nothing. Do you know how to work around it?
Hi, Would like to thank you for sharing this video, this was of great help. However I noticed one loophole, so let's say Suite -> tool -> Category goes like 1. Google -> Tabs -> Questions 2. Microsoft -> Tabs -> Solution. Now this creates a problem coz when we set up a 2nd CD under tabs there is questions and solutions, but for Google as the main head it has only tabs -> solution, now the user will see Google -> tabs -> Here both options i.e. Solution & questions will show up. How to resolve this? is there a way to create multilevel dependency from the first head i.e. suite. I know this is tricky, but if you have a solution please let me know. thanks again!
ty!
Thank you for commenting!
I took a hybrid approach. I use code to manage the 'CD' sheet so it can respond to row or column changes. The code also updates the ranges applied to the dropdowns. Using code I was able to fit all the conditionals on a single sheet. Using the dropdowns is still snappy because there is no code.
Excellent approach!
Thx for sharing
Kind Regards
Hi! How do you apply this with named ranges?
I have 4-5 conditional dropdowns. Is their easier way or what is the recommended way in Google Sheets ? Need this information soon if it is possible. Thanks for your help ! Appreciate it.
I think you may find the guides in any of thes 2 videos
ruclips.net/video/DkCTucLwk4g/видео.html
ruclips.net/video/Lk40x6lzDwA/видео.html
Regards!
it is very close to what I need but it will not work if I work in a mensaual way, I have in a sheet, 3 fields where I have dependent dropdown, if I do it this way I would need 3 conditional sheets for the month of January, there is no problem, but if I do it for the 12 months I do not think it will work, any idea how to solve it?
Hi, thank you for this video! It's exactly what I was looking for and it's very helpful. However, I'm running into an issue. I got it to work, but apparently, it's only for the first 3 cells (within the 2nd column). When I went to the 4th row (of the first column), starting from scratch and selected any of my dropdowns, then the 2nd column, nothing populated for the drop-down lists. I did remove the $, which is why it worked in the first 3 cells. I checked the data validation, and it covers the entire column, not just the first 3. What could have gone wrong?
Feel free to share your file so I can take a look
practical.sheets@gmail.com
Regards!
The website practical sheets seems to be down
Is it not possible to do it like in excel with a simple "indirect" command ? I'm searching for hours how to do it :(
Not possible
Unfortunately you always to have an auxiliary list in Sheets
Kind Regards
@@practicalsheets thanks for your quick answer!
for some reason this doesn't work for me. it ignores the fact that i remove the fixed reference it doesn't care. still remains fixed.
Weird!
Did you try to go again and erase it manually?
Regards!
i want to learn but i dont think that in two hours workshop with so many persons we can learn,....i need separate class for it
I believe each person has a different learning style, and some may benefit from this style of videos, while others, as you, prefer 1-on-1. There is no wrong way of learning (I think). For me the most valuable thing is to always be eager to learn
Kind Regards
Tried following the instructinos but with the go back and forths, I couldn't follow. Tried watching the other videos same thing. Video could be cleaned up so it's more fluid perhaps.
Thank you for the feedback!
Will take it into acount for future videos
Regards!
6:00 He mentions the drop downs, by 10:00 he actually starts showing you how to do it and finishes sometime after talking around himself. This is a 3 minute trick hidden in 100 other lessons and him talking around himself. This was painful to get the answer I needed.....
Thank you for sharing. Im glad you found something useful. Regards!
thank you, but how can i disable error note:
Invalid:
Input must fall within specified range.
I think this error comes out when you use the transpose formula, because it takes the whole row to make that change, if you put something else on the right side on the same row even if it is very layman it still generates the same error, I also get this and I'm trying to solve it.
Keep finding the same problem with these how to video's. No one shows a final working example. As there are many ways of doing something and my need might not fit your way, I need to see something working before i start.
Can it work with more than 3 drop downs?
It should!
I have a video for any number of dropdowns but it does include code
Kind Regards
How to give an option of free text to any of the category in dropdown
You just need to activate the check for "Allow invalid answers"
Regards!
@@practicalsheets thank you
Input doesn't seem to be a Sheets function.
Hello!
You are right, there is no INPUT function
Kind Regards
Definitely not for beginners. It's a bit fast for those who have more experience with dropdowns and understand all the terminology. Had to slow it down and watch it various times because It is exactly what I wanted to do.
I'm getting this error: no matches are found in filter evaluation
Try to use ; instead of .
Great "magic" trick if you want to avoid coding
I hope it is useful!
Thanks for commenting!
Thanks boss
but you were fast with your speech, someone hardly grasps what your saying.
Thanks for the suggestion!
Will work on it for next videos
Regards!
This is 15x more complicated than doing it in excel
But it's fun ❤😂
Agree, Although I´m not a fan of the INDIRECT method in Excel, because you have to create the named range, it is pity you could not include formulas directly in the validation. If they ever do, it would surpass Excel in this regard.
@AkshaySethi91 Agree!
What a mess! Google sheets should create some functionality that is way easier than this.
This channel has a better video using apps script: ruclips.net/video/Lk40x6lzDwA/видео.html
You are right! Is not pretty
Thanks for the shoutout to the other video!
Kind Regards
very long process,
Thank you!
Thank you for commenting!