Filtering Reports to Not Show an Archived Sheet

happinessisland

I have a client that wants a report that will only show active reports. How we indicate that the sheet is active is that we have a row that will state the project's status. Basically, they want any sheet whose row states 'Complete', 'Cancelled', or 'Archived" to automatically not pull up in the report. Is there an easy way to achieve that? The only work around I have is to put the sheet into an Archived folder that the report will not pull from, but I want to know if there's a filter that I can use instead. Thanks!

Ray Lindstrom

Hi @happinessisland

You can move a sheet around to any place you like, and the Report is still going to pull the data. So moving it into another folder will not cause the Report to not pull in the data.

The only way to include/exclude a sheet on a Report is in settings of the Report itself. This cannot be automated unless your coding via the API.