0

I am trying to make Google Sheets send a notification to a particular person/s when one of the fields on column Q is equal to the word "High". I want the email to be sent when it is high because it relates to the priority of the task.

How can I do this?

Any help would be greatly appreciated!

0

To do this you should use a Google Sheets add-on or Google Apps Script. If you go for using Google Apps Script, you could use an on edit installable trigger,the MailApp or GmailApp services and one of the send methods of those services and JavaScript control statements to handle the rules.

Example (untested):

function sendNotification(e){
  if(e.range.columnStart === 17 and e.range.rowStart > 1){
    MailApp.send('manager@example.com','High Priority Task', 'Priority of task on row ' + e.range.rowStart + ' has set to high');
  }
}

References

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.