![]() Setting a data validation parameter in the “year” cell would ensure that if a date was entered for a purchase made before 2020, that value would also be flagged or rejected. In another instance, let’s say you’re entering a list of purchases made in 2020. If a number greater than 100 is entered, you can have Google Sheets either 1) flag that value, indicating that it is outside of your data validation range or 2) reject that input. ![]() You may want to set a data validation parameter in the grade cell that requires any inputted number to be within the range of 0 through 100. Data Validation in Google Sheets allows you to set certain parameters around numbers, dates, and text that prevent you from making input errors.įor example, say you’re inputting exam grades each grade into one cell next to the student’s name. As much as you’re careful about the words you write (or the data you input), it’s always good to have someone check your work and your data. Why data validation mattersĭata validation is like the analytic version of copyediting. Let’s take a closer look at building a drop-down list using data validation in Google Sheets. ![]() Still, many of its best features go undiscovered. Google Sheets is one of the most widely-used spreadsheet tools. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |