Aggregate Summary Field Data from Multiple Sheets

 I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management.  See word doc for details

Any suggestions to the best approach appreciated.


  • Hello,

    After testing multiple different solutions, I was unable to create a stable and efficient method to resolve this.

    If possible, please can you raise an Enhancement Request under "Additional Information" regarding this matter. This request will then be sent to the Product team to consider this feature for a future release of Smartsheet.

    Please reach out if you have any questions!