CODEWITHSUNDEEP
google-sheets
Areki
Areki

Reputation: 41

Google script onedit does not work for referenced cells

I have cells that have an if statement linked to a different sheet using importrange. However, when the status changes to "YES" on my sheet, the onedit script which logs time and date does not run.

However when I manually type "YES" the script successfully logs time and date.

Is there a workaround or an alternative to onEdit to make this work?

Upvotes: 0

Views: 288

Answers (1)

Max Makhrov
Max Makhrov

Reputation: 18717

OnEdit trigger doesn't care if value, returned by formula, changes. It will react only if different value or formula will be entered.

You may use Time-driven triggers.

Upvotes: 1

Related Questions