Data Validation in Google Sheets
In this video, I show how to use data validation in Google Sheets. Data validation is very useful for creating drop-down lists, checkboxes, and validating multiple types of data. In Google Sheets, there are currently seven kinds of criteria you can set up with data validation: list from a range, list of items, number, text, date, custom formula is, and checkbox. I will show you how to use all seven types in this video.
Read through the full tutorial here:
https://www.modernschoolbus.com/data-...
Timestamps:
00:00 Intro
1:02 Creating Drop-Down Lists with List from a Range
2:12 Creating Drop-Down Lists with List of Items
2:55 Number
4:47 Text
5:15 Date
5:52 Custom Formula Is Data Validation
7:47 Checkbox