Calculate RAG Overall Project Status

I have projects that are recording Red, Yellow, Green for multiple categories (Budget, Scope, Schedule, Resources), and I would like to be able to calculate the Overall Health by evaluating each of these individual status' and pulling the lowest color as the overall status. What I need to be able to do is calculate the following:

- IF budget, scope, schedule, or resources is Red, then the overall status of the project is Red.

- IF budget, scope, schedule, or resources is Yellow, then the overall status of the project is Yellow.

- IF no Reds or Yellows (all are Green), then the overall status is Green.

I have tried multiple things and had no luck. Any insight is appreciated! Thanks!

Tags:

Comments