Currently this code is only applied to the sheet called "Name" I wanted applied to all except for 3 sheets (Template,Summary and Count):
function EqualValue() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Name");
var value = sheet.getRange("A5").getValue();
if(value >= "15") sendEmail(value)
};
function sendEmail(value){
var recipient="Tester@test.com";
var subject=" test subject " +value;
var body="The Value is "+value;
MailApp.sendEmail(recipient, subject, body);
};
I am not sure how is best to do this.