Data Validation Custom Formulas Part 2

00:00 Intro to part 2 00:27 Greater than current day's date 02:28 Date must be a weekday 04:47 No more than 15 characters 06:08 Must meet specific phone number parameters 10:14 Whole numbers between 1-20 12:37 Wrap Up

In this tutorial, you are going to learn how to create more useful Data Validation custom formulas that help you to restrict your cell entry for dates and times, word limits, phone numbers and whole numbers.

No only will you learn more about Data Validation, I'll introduce you to Google Sheets functions like TODAY(), WEEKDAY(), LEN(), IS_NUMBER(), TO_TEXT(), REGEXMATCH().

Here is a link to the accompanying post The Monster Guide to Data Validation in Google Sheets, it has more explanations and links to resources for you! https://yagisanatode.com/2021/01/26/the-monster-guide-to-data-validation-in-google-sheets-free-course/

Check out some of my tutorials to get some more information on the subject: https://yagisanatode.com/2019/10/05/google-sheets-counting-and-filtering-rows-where-cells-contain-particular-values/ https://yagisanatode.com/2019/03/02/google-sheets-conditional-formatting-with-custom-formula/ https://yagisanatode.com/2017/12/21/add-the-current-date-when-data-is-added-to-a-cell-google-sheets/

#GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace #DataValidation

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

If you like the video, check out my website: https://yagisanatode.com/

Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/

Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 ... https://www.youtube.com/watch?v=q3CPFR2G-dc