Text Data Validation Rules

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 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 INSTAGRAM: https://www.instagram.com/matttechtidbits/ 🎵Music is "WFH" by Ambiosynthesis https://www.youtube.com/watch?v=sKi5cGTQoBM — #️⃣ #sheets #spreadsheet #googlesheets #technology