Google has added data validation (lenient or strict) to Google Spreadsheets. You can now:
- Validate numbers, dates, and text.
- Prevent users from entering text that doesn’t match your criteria, or show them a comment on the cell when the data doesn’t match the validation rule.
- Add text to the cells you add validation to, to help your collaborators enter the right type of data.
Learn more here.