👍 The Monster Guide to Data Validation in Google Sheets: Free Course

Liked The Monster Guide to Data Validation in Google Sheets: Free Course by Yagi (yagisanatode.com)

1. 00:00 Intro to custom formulas in data validation part 2.
2. 00:27 Greater than the current day’s date.
   1. Formula example: =B6>TODAY()
3. 02:28 Date must be a weekday.
   1. Formula example: =AND(WEEKDAY(B7) <> 7, WEEKDAY(B7) <> 1)
4. 04:47 No more than 15 characters in the cell.
   1. Formula example: =LEN(B8) <= 15
5. 06:08 Must meet specific phone number parameters.
   1. Formula example: =AND(LEN(B9) = 10, NOT(REGEXMATCH(TO_TEXT(B9),"D|s")))
6. 10:14 Whole numbers between 1-20.
   1. Formula example: =AND(ISNUMBER(B10),
NOT(REGEXMATCH(TO_TEXT(B10),""[.]"")),
B10>0,
B10<21)