Dashboard Chart

Liz_Snavely

I want to create a single dashboard chart that shows the total work planned vs the total work unplanned. I created two reports and added filters and counts; one for planned work and one for unplanned. How do I pull the counts from each report to display in a single dashboard chart?

Kiela

I create a metric sheet and use a formula to count up what your key identifier of each are.

Liz_Snavely

Thanks Kiela. Can I have a metric sheet pull from another sheet? The problem is I would need to create two metric sheets and then use both to populate the graph.

Paul Newcome

You would use a single metrics sheet and have one source sheet referenced in one column and the other source sheet referenced in another column. You can't combine sources to create a single chart.

Liz_Snavely

How do I filter the data in a single metrics sheet to get both numbers I need for the chart? Right now, I have one source sheet and two reports. It sounds like I need to create a metrics sheet in place of the two reports, but I don't know how I would create the various filters I need in a single metric sheet.

Paul Newcome

You would use formulas with cross sheet references such as COUNTIFS, SUMIFS, or AVG.

=COUNTIFS({Status Column}, @cell = "Red", {Type Column}, @cell = "Type A")

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references