Aggregate Red, Yellow, Green Status to One Overall Grade
I am looking to Aggregate Red/Yellow/Green status into one overall R/Y/G. Here is the criteria for grade 1:
- All classes are either yellow, or green, overall grade = green
- 3 classes at yellow, overall grade = yellow
- Any one class at red, overall grade = red
Here is what I have tried,
=IF(AND([Grade]@row = "1", (OR([Class 1]@row = "Yellow", [Class 2]@row = "Yellow", [Class 3]@row = "Yellow")), (OR([Class 1]@row = "Green", [Class 2]@row = "Green", [Class 3]@row = "Green"))), "Green")
This is not working as expected. Any thoughts on what I am doing wrong here?
Help Article Resources
Check out the Formula Handbook template!