Data validation allows users to test the integrity of the contents of a cell based on validation rules. In this video, Jess Stratton shows you how to create validation rules based on the contents of cells, and even add drop-down lists to cells.
- [Instructor] You can make sure the integrity of your data…stays nice and clean by using cell validation.…You can validate every cell to make sure…the formatting fits certain criteria…such as data, text strings, or even restricting values…to a drop-down list of choices.…Google Sheets makes it incredibly easy to add validation.…Let's add some validation to this email column…to make sure a valid email address is entered.…I'll start by clicking the column header in D…to select the entire column.…From here, click Data,…and all the way on the bottom, click Validation.…
First, I need to check and make sure…the correct cell range is covered.…In this case, it's the entire column of D.…That's what I want.…The next step is to choose the criteria.…If I click the drop-down next to List from a range,…here's all of the validation I can do.…I'll go over range values and a list of items later,…but you can also validate based on number,…text, date, even a custom formula that you create.…I'm going to click Text for now.…Once I click Text, I get a further drop-down,…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.