3 dependent dropdowns in Google Sheets with no code - 2023

Thanks for saving me! hahahaha I did this many years ago, so I knew there was a way...

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?

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.

This was so helpful! you are a life saver. :')

This is 15x more complicated than doing it in excel

Thank you so much. This was exactly what I needed, you are a life saver!

Muito bom! Obrigado por compartilhar!

Thanks boss
but you were fast with your speech, someone hardly grasps what your saying.

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.

Excellent Explanation ! Kudos from India :-)

Thanks, Buddy, I have used it.

thank you, perfect

The website practical sheets seems to be down

Very Useful ! Thanks a lot !!!

This saved my life. I was seaching for this. Thank you so much. 🤌

Really it's very helpful to me, I watch several video but this the best and simplest. Thanks a lot.

How to give an option of free text to any of the category in dropdown

I'm getting this error: no matches are found in filter evaluation

Hi! How do you apply this with named ranges?

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🙏

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!