Aggregate Summary Field Data from Multiple Sheets

TRMakai

 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

Situation.docx

Any suggestions to the best approach appreciated.

Sean Morgan

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!

Regards

Sean