How I send e-mails between two sheets?

Hey, guys,
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/

sendEmail_how

Help, I need somebody

Sorry I have no idea what you mean by your question.

If you are sending emails via a script they are not tied to any particular sheet. You can pull the data for the email from any sheet you want via the script.

1 Like

tks