Is it possible to change multiple report filter values without manually changing each one?


BACKGROUND: I have a template folder containing a number of simple reports, each referencing a separate, singular sheet, each filtered on its own key value column, but they're all filtered to the same key value as every other report in the folder. When this template folder is copied, it needs to have all the reports therein filtered to a new key value. Right now someone has to do that by manually going in each report and updating its filter to the new key value.

QUESTION: Is there a way to filter the reports so that I can change a value once somewhere to the new key value, which would automatically update all the report filters to that new key value, without having to manually change each report's filter? (It would be really nice if the API exposed report filters, but it doesn't)

Best Answer