πŸ‘ 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 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)

Leave a Reply

Your email address will not be published. Required fields are marked *