Summary Reporting from a Single Smartsheet

Gladys Liley

I have a single sheet used to log test defects.  From this sheet I've created a summary section at the top for Open Items and Items by Status.  I need to create another summary "Item Status by Sprint versus Production".  I've tried Reports but this does not allow adding a summarization of the data (equivalent to an Excel Pivot).  I've tried to create a cell link but at this point I have 439 items and may reach limitations.  Any suggestions are greatly appreciated.

Thank you,

Gladys

Patrick Briscoe

Hey Gladys -

If I'm understanding your request appropriately, you may be able to use Parent/Child row functionality to more conveniently summarize data, which can easily be used with nested CHILD formulas to summarize the data.

For example: if you use Parent rows to organize your data, and use Child rows (indented) to summarize the data, you could then create a formula for the summary using a formula such as =SUM(CHILDREN($Column$Cell#), CHILDREN($Column$Cell#)) etc.  This way you can keep the data together in the sheet itself, whereas the individual data summaries you need will be able to be conveniently used within a formula.