Skip to main content
edited tags; edited title
Link
user79865
user79865

Send Emailemail If Statement JavaScriptone cell is greater than or equal to another

Source Link

Send Email If Statement JavaScript

For some reason this script is not working and I was wondering if someone may guide me on fixing this?

In my Google Spreadsheets, I just want the value in cell A2 to send an email if it's greater than or equal to the value in B2. I have gotten it to work if it's a specific number or word but not sure if it what I'm doing wrong here to compare cells.

function ifstatement() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName("data"); var value = sheet.getRange("A2").getValue(); if(value >= "B2") sendEmail(value) }; function sendEmail(value){ var recipient="[email protected]"; var subject=" test subject " +value; var body=" test body "+value; MailApp.sendEmail(recipient, subject, body); };