79644238

Date: 2025-05-29 16:10:39
Score: 1.5
Natty:
Report link

is it possible that the dest sheet that contains IMPORTRANGE periodically tries to refresh from the source sheet and this in turn is considered an OnChange event? Thanks!

No. Upon testing as well it doesn't work that way. The onChange event does not automatically trigger when an IMPORTRANGE formula refreshes its data in the destination sheet, it only triggers when:

An installable change trigger runs when a user modifies the structure of a spreadsheet itself—for example, by adding a new sheet or removing a column. See Installable Triggers.


This is also supported by the official documentation where it says:

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Long answer (-1):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Starts with a question (0.5): is it
  • Low reputation (0.5):
Posted by: Gyul