The Report Builder forgets which custom search filter belong to which sheet

Typically these reports are used to pull raw data into one sheet, which is then transposed, filtered and analyzed in a second or third sheet (i.e. pivot tables and charts). You can then update your charts without ever having to switch back to the initial raw data. If Solve’s Report Builder remembered the settings for each sheet, it would have to return to the raw data sheet each time it wanted to update the charts.

For those who want to run multiple reports, pivot tables or charts and be able to update them at the click of a button, the best practice is to create a new Google Spreadsheet document for each one. Each document has its own instance of the Solve Report Builder add-on, which will retain its own settings.