onEdit will not trigger

Hi,

I have a script using the onedit trigger within google sheets, which does not trigger when Appsheets edits a cell.

I have read a few topics that suggest to use onChange rather than onEdit, however my script uses events to determine what cell it needs to update, i.e. if A1 is edited update B1, or if B1 is edited update C1.

If I modify the script to onChange, I do not get an event to determine the cell that was updated.

Has anyone got any workarounds please

0 5 6,021
5 REPLIES 5
Top Labels in this Space