If a field is is changed in a row I need an email to be sent to the email that corresponds with the row. For instance say in a row the first field is 1234@gmail.com, the second is a description field and the third is a field that says in progress. I need an email to be sent to that email address when the in progress field is changed by another user
How to set up email notifications to specific accounts when a field is changed?
google spreadsheets