I'm a school teacher using Google Forms and would like to generate an email to myself, and if possible other collaborators, based on an text answer of "YES" in column B from the sheet generated by that form. I've been looking on here for a couple days and can't find exactly what I need. And I only know enough about this stuff to get myself in trouble. :)
There must be a simple script that basically sends me an alert email ONLY if someone types in an answer of "YES" for a particular text question (the answer shows up in column B on the form sheet responses, otherwise the response is left blank).
If it matters, I'm running a script for "formemailer" on the sheet as well to return copies of the responders answers back to them.
I do NOT want to have an email sent to me every time someone submits a response to the form - I already know how to set that up.