Calculate RAG Overall Project Status

ASorensen
ASorensen
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!