I’ve created long time ago a spreadsheet with several scripts using Google Scripts, one of the primary functions was related with onEdit() function, which worked perfectly until last week.
I’ve been reading some posts here to change the function from Simple trigger to Trigger, but didn’t work, as while Simple Trigger is considering the written code which only is enabled if a specific cell is enabled, but by modifying to Trigger, the options are onEdit or OnChange, and both are acting over any change in the entire spreadsheet.
My biggest issue here, is that this a highly costumed dynamic report, hence, this particular trigger is re-creating all the charts that are in the spreadsheet, so, every chart deleted or created is a trigger for this script under the Trigger option.