A Solution for Listening Formulas on Google Sheet Watch Changes

How To
1

Hey,

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!

2

Hey @onurbolaca is the change being implemented by the user or is it manually? Check out
https://www.make.com/en/help/app/google-sheets#watch-changes-964718 the watch changes only for changes made in the Google Sheets app by the user.

2 Likes