0

This is my situation:

  • Spreadsheet is set to recalculate on change and every minute
  • One of my cells has a formula that pulls data from an API
  • The combination of the two makes my cell value change from time to time

I want to run a script once the value of this cell is changed.

I tried to use onEdit() but it seems to trigger only when a user changes a cell, not when a formula changes it value.

What would be the right trigger for that?

Improve this question
0

1 Answer 1

Reset to default
1

A trigger is not enough.

You have to set a way to record a base value. Then, among other alternatives, you could set a time-driven trigger that call a script that compares the current value to the base value, if they are not the same then update the base value and do the other things that you require when the formula calculated value changes, otherwise do nothing.

To record the base value, you could use an spreadsheet cell or the Google Apps Script Properties Service.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.