I would like to create a custom function for Zoho Sheet that triggers when a paticular cell changes to a specific value. This would result in sending an email to a recipient (this would be an address that remains the same and included in the script).

Example:

= IF(N4= "Drafted", <>EmailFunction)

1)     Cell N4 changes to "Drafted"

2)    Email is sent to recipient

           or alternatively

3)    Post to chat channel

I have found the Custom function editor in Sheet. I am not bad at scripting, but I have yet to find a full list of functions and syntax for Deluge? Can anyone give me an example of this script I can work with?

Much appreciated!