How I send e-mails between two sheets?

Ask for Help
1

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 = Sample code sending email when Google Sheet is updated · GitHub
I’m following this idea = How to send email when cell value changes in Google Sheets | blog.gsmart.in

sendEmail_how

2

Help, I need somebody

3

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
4

tks