Overall RYG Health Formula Based on Other Combined RYG Columns
Does Anyone Have a RYG Formula that Looks at 3 Other RYG Columns to get the Over Health I Could Leverage?
Scenario 1: If All 3 Columns are Green, then Overall Health is Green
Scenario 2: If All 3 Columns are Red, Then Overall Health Red
Scenario 3: If All 3 Columns are Yellow, Then Overall Health Yellow
Scenario 4: If All 2 Columns are Yellow and 1 is Green, Then Overall Health is Yellow
Here are is The Formula Column:
These are The Columns it is Referencing:
Help Article Resources
Check out the Formula Handbook template!