Data Validation Logic: Checking Form Responses with Formulas
This lesson is part of the course
In this lesson
You check bean orders that came in through an online form: is the email plausible, is the quantity a whole number of kilos within the limits, and is the delivery date inside the window?
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Sharing-Ready Tables: Tidy Data, Totals and Checks Locked
- SUMIFS and COUNTIFS Reports (and QUERY in Sheets) Locked
- Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH (plus IMPORTRANGE) Locked
- Text and Dates: Clean Names, Build IDs and Due Dates Locked
- Data Validation Logic: Checking Form Responses with Formulas Locked
- Conditional Formatting for a Shared Inventory Sheet Locked
- A One-Page KPI Dashboard with a Chart Locked
- Team Task Tracker: Status Counts and Overdue Items Locked