Help with getting metrics for project health

mrodriguez

I have a project portfolio that I am trying to report off of. I am trying to get a count of the amount of projects for each health category (red, yellow, green, gray) for a specific sponsor. I do have a helper text column correlating to the health.

Below is the formula I tried.

=COUNTIFS({Copy of IT Project Portfolio Range 3}, [Primary Column]@row, {Copy of IT Project Portfolio Range 1}, [Column2]@row, {Copy of IT Project Portfolio Range 4}, [Column3]@row)

I would also like to be able to track this month over month what the changes are.

Thanks!!

nschildt

Hi @mrodriguez - Will the sheet you are currently showing only have 1 line per color or could you have multiple color lines with different names and also different status? Will this list continue to have items added to it, or can items be added and removed at any point in time in the month?

mrodriguez

Hi @nschildt each line will represent a new project & each project will have it's own color, they will also have their own status but I am looking to only represent one status "In Progress" The list is the project portfolio so it will consistently have new line items representing new projects.

nschildt

@mrodriguez - Let me know if this is what you were looking for in the counting portion? I can then assist in the Tracking MoM.

=COUNTIFS(Health:Health, Health@row, Name:Name, Name@row, Status:Status, "In Progress")

Paul Newcome

Try doing each of the three range/criteria sets one at a time to see which one(s) give you a zero. That will help narrow down where the problem is.