Hi, is it possible to create a trigger to refresh queries on a single sheet tab instead of the entire document?
I am trying to create a pacing report so it would look something like this
Week 1 sheet triggers on 7th
Week 2 sheet triggers on 14th
Obviously I can create 4 different documents and import into a master report but am hoping to avoid that and just have everything in one document.
unfortunately due to fact that the triggers rely on Google Appscript, it's not possible to target only certain queries with the triggers.