Reports - Need an easier way to view all source sheet from the selection window.

mcullen

Hello! We utilize a report that has 100+ source sheets. We've discovered a few sheets are missing and I need to cross reference a list of all the sheets that should be on the report with what is already on the report. Is there an easier way to do this besides scrolling through the list of 100+ sheets or having to type the source sheet name into the search bar? It's incredibly challenging and time consuming when there are so many sheets and the list is not in alphabetical order.

Kelly P.

@mcullen You could save that report as new so you have a copy. Then, in the copy, remove all of the filters, groups, summaries, and sorts. Ensure that the Primary field is not hidden. Add in the Sheet Name field. Then group (collapsed) on Sheet Name. You'll then be able to see a list of all of the sheets, in alpha order, that are included in the report.

Hope that helps!

mcullen

It's worth a try. Thank you @Kelly P.!