Pre-Filter Summaries in Row Report

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!