Formula for Metric Sheet - Dashboard Chart

ejacksonBPT

Hello, I'm trying to create a metric sheet calculating statuses per Project Manager. I want to use this create charts on my dashboard. I want a pie chart for each Proj Manager showing the three statuses. I think I know how to create the chart if the data is there.

My sheet looks like this:

I think I'm almost there, but stuck trying to get it to specify by Poj Mgr Name:

DKazatsky2

Hi @ejacksonBPT,

There are 2 ways you can setup the metric sheet, but the main thing is to change the formula to =COUNTIFS to include multiple criteria and add another cross sheet reference for Project Manager.

Example 1:

Change the formula by adding in the project manager name in each formula.

=COUNTIFS({Status}, [Primary Column]@row , {Project Manager}, "Joe")

Example 2:

Instead of using the Project Manager names as column names, move everything down one row and add the names into the sheet itself, this way you can refer the project manger name inside the cell, the same war you are doing with status - this will make it easier to make changes in the future. Then use the following formula.

=COUNTIFS({Status}, $[Primary Column]@row , {Project Manager}, [Column2]$1)

Note the "$" - this will make it so you can drop the formula across or down without it changing the required cel.

Hope this helps,

Dave