Pre-Filter Summaries in Row Report
Kevin7859
✭✭✭✭✭
I have created a row report and my supervisor wants to see the summary of all site visits conducted, but filter the report to show only the visits that resulted in issues.
I can summarize the report before the filter and after, but the Counts change once the filter is applied to show only the items with greater than zero issues.
So the county of visits shows as 428 total visits, but once I apply the filter that count changes to 226, but my supervisor wants to retain the pre-filter count in the report. Any ideas?
Answers
-
Hi @Kevin7859
- Create a summary field with the total visits.
- Create a field that then pulls that in.
- Then include that field into the main report
- To make sure it stays at the top use a flag of some sort so that it is a line on its own.
Thanks
Purnima
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!