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

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!