Updating Overall Status based on 3 other Statuses
Hello, I need help writing a formula for the Overall Health cell based on the Scope Health, Budget Health, and Schedule Health cells.
If any of the 3 cells are yellow, Overall is yellow. If any of the 3 cells are red, Overall is red. If all 3 are green, overall is green.
Help Article Resources
Check out the Formula Handbook template!