If you nee more than two different choices like checkboxes, Dropdowns are the way! This allows for multiple specific criteria to be used within the given cell(s). In this video we will dive into the different options we have in Google Sheets using dropdown data validation!
⏳Timestamps:
0:00 Introduction
00:34 Insert Dropdown
01:01 Dropdown Criteria
02:00 Dropdown From a Range
03:35 Access Data Validation Rule From Dropdown
3:46 Change Dropdown Colors
4:26 Advanced Options in Dropdowns
5:13 Reordering Dropdown Order From Data Sheet
5:53 Reorder Data With Helper Column
8:47 Coping Dropdown Rules to Other Cells
9:40 Dropdowns for Employee Names
10:45 Limitation of Two Dropdowns on Ranges
11:18 Dynamic Dropdowns Overview
12:50 Conclusion
13:18 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
Негізгі бет Ғылым және технология Dropdowns
Пікірлер