Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Summarize Columns in a REPORT, not a Worksheet
I've looked far and wide, and haven't found a way to summarize column data in a Report. My team uses a single "Status Tracking" Smartsheet, which has a large number of columns. For some of the columns in that worksheet, I have created Summary Rows with Count or Average Formulas, so I can determine the number of records for a given record type. This functions just fine in a worksheet. However, I have also created some reports, which are based off of the Status Tracking sheet, so that I can narrow down the number of columns to a much smaller subset for executive consumption. Problem is, I still want to display the number of records in the report iself, so that Executives could see how many records are "On Hold", or "In Process", etc.
I've not found a way to do this in a Report. Am I missing something? I can do it in a Sheet, and can even display that record in the Report, but it doesn't update according to the Report filters.