Help with getting metrics for project health

edited 05/30/24 in Formulas and Functions

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!