(New Method!) Dynamic Dependent Dropdowns

Here's a more advance lesson that covers dynamic dropdowns! An update in 2024 made it way easier to create these! ⏳Timestamps: 00:00 Introduction and Review of Dropdowns 01:03 What is a Dynamic Dropdown 01:30 Creating Data Tab for the Dynamic Dropdown 02:44 Referencing Department Dropdown 04:10 Filter Employees Based on Departments 06:04 Verify Filter Pulls Correct Data 06:25 Change Filter to Rows Using Transpose Function 07:42 Adding Dropdown Rule for the Dynamic Dropdown 08:36 Check Dynamic Dropdown Matches Data 10:04 Dynamic Dropdown Overview and Tips 11:37 Conclusion 12:03 End Slides -- ✅Section 1: Organization https://docs.google.com/spreadsheets/d/1SbRW5LJS5P1A5ZA1hxZv3Hnv3bos-dl-e0F96KCuLrA/copy ✅Section 2: Formula Building https://docs.google.com/spreadsheets/d/1nQF5cN3F_QienoZ2hK87L_xoC0Rc8apNrm7PVA5LaHo/copy ➡️Section 3: Data Validation https://docs.google.com/spreadsheets/d/1kA9gqFX1d-tAA-y6vWUHAtS9xglwCOAx2XuHodrkkJc/copy -- 🗣️Socials: WEBSITE: https://matttechtidbits.github.io/matttechtidbits/ REDDIT: https://www.reddit.com/user/MattTechTidbits LINKEDIN: https://www.linkedin.com/in/matthew-klemme-ba9126b2?trk=pub-pbmap INSTAGRAM: https://www.instagram.com/matttechtidbits/ 🎵Music is "WFH" by Ambiosynthesis https://www.youtube.com/watch?v=sKi5cGTQoBM — #️⃣ #sheets #spreadsheet #googlesheets #technology