I’m listening X sheet which all its new data is coming from Y sheet through formulas.
When a change happens in my X sheet through formula, it doesn’t trigger watch changes. I need to use my X sheet for automation.
Do you have solutions for this problem? I want to be able to listen any change even through the the formulas