A Solution for Listening Formulas on Google Sheet Watch Changes


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

Thank you!