2024 Dynamic Dependent Dropdowns

Here's a more advance lesson that covers dynamic dropdowns! A recent update made it way easier to make 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/...

✅Section 2: Formula Building
https://docs.google.com/spreadsheets/...

➡️Section 3: Data Validation
https://docs.google.com/spreadsheets/...
--

🗣️Socials:
WEBSITE: https://matttechtidbits.github.io/mat...
REDDIT:   / matttechtidbits  
LINKEDIN: https://www.linkedin.com/in/matthew-k...
INSTAGRAM:   / matttechtidbits  


🎵Music is "WFH" by Ambiosynthesis
   • WFH  
—

#️⃣
#sheets
#spreadsheet
#googlesheets
#technology