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. 
An answer in column B on Google Sheets generated from a Google form sends email to collaborators including all data in that row
google spreadsheets;google forms