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
docs.google.com/spreadsheets/...
✅Section 2: Formula Building
docs.google.com/spreadsheets/...
➡️Section 3: Data Validation
docs.google.com/spreadsheets/...
--
🗣️Socials:
WEBSITE: matttechtidbits.github.io/mat...
REDDIT: / matttechtidbits
LINKEDIN: www.linkedin.com/in/matthew-k...
INSTAGRAM: / matttechtidbits
🎵Music is "WFH" by Ambiosynthesis
• WFH
-
#️⃣
#sheets
#spreadsheet
#googlesheets
#technology
Негізгі бет Ғылым және технология 2024 Dynamic Dependent Dropdowns
Пікірлер: 2