I have a google form that populates a spreadsheet with a timestamp and two numbers.
For technical reasons I can't have the numbers passed directly into a database but they need to be copy-pasted individually. I have a worker who does this daily (there are only 5-10 each day) and I'd like to get an email alert if the un-entered numbers exceed X.
In this sheet, columns A, B, & C are filled by the form. The worker, for each row, copies the formula in E down a row and then copy-pastes the result. After the number is successfully added they write "Yes" in column F.
I know how to setup an email notification for any change in the document. What I don't know and would like help with is how do I set up an email notification for a specific change.
For example, if the count of the number of rows that have values in columns A, B, & C but no values in F exceeds 20, send me an email.