Overall Project Health Formula

Jess S PDX

Hiya folks,

We want one field to show Overall Project Health. Ideally, we would figure out how to average the colors and/or tasks past due to return RYBG for the overall projects (about ~230) so that we can report it on a Dashboard. Any ideas on formula would be so appreciated.

Circular reference error formula in OPH row: =IF(Level@row = 0, =AVG(Health:Health), "")

Blocked error Health row formula: =IF(Summary@row = 1, "", IF(Level@row = 0, [Overall Project Health]@row, IF(OR(Status@row = "Complete", Status@row = "Cancelled/NA"), "Blue", IF(AND([Recommended Due Date]@row <= TODAY(), Status@row <> "Complete"), "Red", IF(AND([Recommended Due Date]@row <= TODAY(-3), Status@row <> "Complete"), "Yellow", "Green")))))

Grateful for any guidance others may have.

kowal

Hey Jess,

I think the best practice for overall project health is using the Weakest Link formula.

You can read more about it in this pdf:

Weakest Link

Let me know if it helps.

kowal

Hey Jess,

I think the best practice for overall project health is using the Weakest Link formula.

You can read more about it in this pdf:

Weakest Link

Let me know if it helps.

Jess S PDX

This is great, thank you so much!!!