Sheet Summary Report Builder only shows the system columns

amwright100876
edited 12/09/19 in Smartsheet Basics

I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge together data from columns other than the system columns. Am I doing something wrong? 

ReportBuilder.png

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Geoff Baker

    Just to clarify, there are two different types of reports. There's the Row Report which looks at the grid data and rows in your sheet(s), and there's the Sheet Summary Report which only looks at the Sheet Summary field(s) in your sheet(s). You can select which type of report you want to build when creating it for the first time.

    Here are two Help Center articles that go over the different types:

Answers