In this video we look at the Text Data Validation Rules. While most are pretty self explanatory we will dive deeper into what data validations do, and how we can create similar rules for filtering using Functions.
⏳Timestamps:
00:00 Introduction
01:20 Text Contains
02:38 Text Does Not Contain
04:43 Text is Exactly
05:22 Text is a Valid Email
06:18 Text is a Valid URL
07:05 REGEXMATCH() for Text Contains
08:36 NOT(REGEXMATCH()) for Text Does Not Contain
09:39 IF() for Text is Exactly - or EXACT()
10:15 ISEMAIL() for Text is a Valid Email And ISURL() for Text is a Valid Email
10:38 Data Validation Rules Work as TRUE or FALSE Statements
10:55 Using a Data Validation Rule vs. Formula
11:45 ? (Question Mark) Wildcard To Match any Single Character
12:50 * (asterisk) Wildcard To Match Zero or More Characters
13:51 ~ (tilde) To Escape A Wildcard and Match a ? or *
14:37 Wildcards Don’t Work with Every Function!
15:39 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
Need a Freelancer? Check out my Upwork Profile:
www.upwork.com/freelancers/~0...
🎵Music is "WFH" by Ambiosynthesis
• WFH
-
#️⃣
#sheets
#spreadsheet
#googlesheets
#technology
Негізгі бет Ғылым және технология Text Data Validation Rules
Пікірлер