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!