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?