Programme level reporting - cell linking Vs. sheet summaries

LisaB:-)

Hi, I'm building programme level reporting which spans about a dozen projects. At the moment, I'm testing two routes - 1. sheet summaries and then a sheet summary report, and 2. cell linking. Cell linking is looking like the preferred option because sheet summaries aren't dealing very well with percentage formatting, at the moment. It seems that sheet summaries don't offer any clear advantage over cell linking, however, I do wonder if multiple links would make my sheets slower and less robust. I'd appreciate thoughts and advice on the advantages and disadvantages of each method, many thanks.

Stefan

Hi Lisa,

in my larger projects I almost always use cell links to build summary sheets.

Sheet summaries are nice, but you cannot aggregate data from sheet summaries. So if you need to maybe aggregate project data for different target audiences you better use summary sheets. This also leaves space for additional levels of aggregation. Since Smartsheet raised the limits some time ago, I never had any performance issues due to cell links.

Hope this helps

Stefan

Stefan

Hi Lisa,

in my larger projects I almost always use cell links to build summary sheets.

Sheet summaries are nice, but you cannot aggregate data from sheet summaries. So if you need to maybe aggregate project data for different target audiences you better use summary sheets. This also leaves space for additional levels of aggregation. Since Smartsheet raised the limits some time ago, I never had any performance issues due to cell links.

Hope this helps

Stefan

LisaB:-)

I'm going to do cell linking, thanks so much for your insight.