Creating Custom Formulas using simple regular expression for Data Validation in Google Sheets

00:00 Intro 00:09 Basic example 01:54 Removing data validation 02:02 Must contain the word 05:03 Must contain at least one word from a list 07:01 Must start with a word 08:09 Must end with a character 09:34 Wrap up

You can actually create novel data validation rules in Google Sheets using the Custom Formula criteria. In this tutorial, we will explore how to use the Google Sheets function REGEXMATCH to create our validation rules.

You can learn more about regular expressions in Google Sheets by checking out these introductory tutorials:

• 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/

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/

#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/ ... https://www.youtube.com/watch?v=2WZt26rN27Y