I need users to receive an email notification when a cell is set to their name.
In the attached file, you'll see Column G shows a name value selected from a menu.
Whenever this value is set, I need to email that person with this subject:
You've been assigned + (Column A same row value).
The message text can say the same thing.
I have a second sheet that holds a list for Col A = Name, Col B = Email address.
I'll pay you to write the script and send it to me to implement and test.
Hi. Great app writer for your projects. I have writen excel, googlesheet app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile