Check out How to moderate data input into a spreadsheet by Sarah Maddox. Here is an excerpt:
A smart engineer suggested a lightweight way of moderating data coming into a Google Sheets spreadsheet. I’m sharing it here in case you find it useful. Note that this is not an official Google solution, and anything on my blog is my own opinion or idea, not Google’s.
This idea came from