I'm trying to create SUMIFS summary formula's so that I can use the values in a dashboard.

teresa.hron92846

https://app.smartsheet.com/sheets/2rRMWQV6RH42W7mhC7P9FwRW3p288vVR65PjcxC1?view=gantt

I would like to summarize the planned and completed work using the following fields and group by SubType.

Planned is anything <> Backlog or Group

Complete is anything where status = Blue

Points represent the relative size of the work.

Ultimately I am looking to add a circular graph per subtype to a dashboard showing how much of the product is complete and what is planned.

Any help you can provide would be much appreciated.

Joanna Waligora

Hi,

I (and chances are most folks) don't have permissions to view your project space. It would help if you could include a screen grab of your field configuration.

In the meantime...there was a similar question asked here: https://community.smartsheet.com/discussion/comment/248564#latest

Maybe that will help.