The Google Sheets add-on 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 add-on 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 CRM add-on, which will retain its own settings.