summary of sheet summaries
My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summaries to be combined (sum, average, count etc). I realize I can create a metric sheet that makes use of formulas and reference to each sheet but since I have already set up sheet summaries, it would be a lot easier if I can just combine the sheet summaries (i.e. summary of sheet summaries). As you all probably know referencing multiple sheets with conditional formulas can be a pain if you have a lot of sheets and different conditions you are querying. I realize I can create a report that pull information across multiple sheet summaries but reports do not allow calculation. Any workaround to this (other than create a metric sheet with formulas)? I hope Smartsheet has a plan to offer this capability in the near future.