Here’s how to add a pre-defined drop down list in Google Sheets. So that you can get a standard input from the users.
Go to Data > Validation..
When you have multiple users editing the same Google Sheets, you might want to have an alert or notification when someone in the team make any changes.
You can set the notification as below.
1. Choose Tools > Notification rules…
2. Select the options and click on Save button.
That’s it. Once it is done you will receive emails when something is changed on your shared Google Sheets.