I would like to watch changes in specific range of cells in google sheets, and those cell ranges are separate. (eg: column A and D). I dont want to react (even void) to changes in columns B and C, cause there are modified a lot and I dont want empty runs so often. How can I add a range (in make extension settings) that consists of two separate ranges? I’ve tried A1:A1000;D1:D1000, {A1:A1000;D1:D1000}, =A1:A1000;D1:D1000 - all no success. (actually thats quite annoying A:A doesnt work too, but thats not the thing I want to solve right now). Thanks for any help!
Hey Przemek,
for Google Sheets I mainly use App Scripts as they are much more customizable. You can write an app script to watch exactly what you need and have it call a Make webhook to process that info further. Hope this suggestion helps.