Report Filters: including new sheet forces filter recreate?
Hi.
I have a report that includes all sheets in a Workspace. The report has filter criteria. I found that any time I add a new sheet to the Workspace, the rows from the new sheet don't show up in the report until I remove the report filter critera and recreate the same filter.
Is this expected behavior and how can I prevent it? It is impacting adoption by my team members because every time they add sheets, I have to update 3 reports,
Regards,
Ian
Answers
-
Hello! Do you have the Workspace selected from the report filter or the individual sheets within the Workspace?
If you have the Workspace selected, not individual sheets, any new sheets should automatically be accounted for in the report and filter.
-
Yes, I have the workspace selected
-
Hi @3blazeP
Is it possible you have a Folder selected versus a Workspace? Can you post a screen capture like @Victoria_Indimar did above, but block out sensitive data?
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hey @3blazeP
Selecting a Workspace should automatically include new sheets into this Report, as long as they have at least one of the same columns that have been selected and their rows aren't filtered out.
You may need to refresh the Report if you were currently in it when the new sheets were added, but you should not need to un-do and re-do the filter to bring in those rows.
Is there any possibility that your newly created sheets don't have the same column types / names or that the filter needs to be re-done because there's new criteria?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Could it be that the sheets had columns with different names and then I changed the names to match the report criteria? SO the names were originally different but then the same causing a re-filter to be required?
-
Hi @3blazeP
As long as the column names and types are made to match, you should only need to refresh the Report for those rows to be included (no edits to the filter needed).
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives