I have a script to send email, I do a calculation on one sheet (calculates the percentage) and on another sheet (if OK or Not OK) it checks and if it sends the email.
How do I do that?
Change information on one sheet and send email from another sheet
Script = https://gist.github.com/prasanthmj/f003df8ee22e37bda45032cdaa7dd690
I’m following this idea = https://blog.gsmart.in/send-email-when-cell-value-changes-in-google-sheets/