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
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!