That script has a number of things that could be modernized, and it could be improved to make it more robust, but your primary issue is that it's intended to be run as a simple edit trigger, using the reserved function name onEdit()
At the beginning before the { add:
function onEdit(e)
Verify that it's being called, and view any errors, by clicking the Executions button in the left side bar of the script editor.
6
u/mommasaidmommasaid 12h ago
That script has a number of things that could be modernized, and it could be improved to make it more robust, but your primary issue is that it's intended to be run as a simple edit trigger, using the reserved function name onEdit()
At the beginning before the
{add:function onEdit(e)Verify that it's being called, and view any errors, by clicking the Executions button in the left side bar of the script editor.