https://docs.google.com/spreadsheets...gid=1451036760
This is the sheets I am working on, on the Quota Capacity Recommendation sheet I am trying to have emails automatically sent if the value in the column "Actual productivity per-hour" is >(1.15*"Quantity demanded per-hour") or Actual productivity per-hour (<1.15*"Quantity demanded per-hour").
This is what i have so far but i am getting a error one the MailApp.sendEmail line.
function myFunction() {
var ss = SpreadsheetApp.getActive();
var sheet = ss.getSheetByName('Quota Capacity Recomendation');
var qdph = sheet.getRange(F2).getValue();
var apph = sheet.getRange(G2).getValue();
var rc = sheet.getRange(I2).getValue();
var name = sheet.getRange(A2).getValue();
{
if(apph>(1.15*qdph) || apph<(1.15*qdph))
{
MailApp.sendEmail(voluntaryamnesia@gmail.com,+name+ Quota Recomendation, +name+ has reccomended quota change of:, +rc+ “.”);
}
}
}
Bookmarks