Hi everyone,
I am working on a formula around RAG statuses attached. In short a programhas a RAG (OverallProgramHealth), and if this is Green for example none of columns be Red or Amber. If OverallProgramHealth is Amber, then at least 1 column must be amber, and the same with Red. If these conditions are not met, the score is 1, if they are met, score is 0.
However....if the Overall Health (B) is Amber lets say and non of C-G are Amber, this should also flag as incorrect (1) and not 0.
Make sense?
I can get the first half of this to work but not the second! Can anyone help?
Data.PNG
Formulas.PNG
Bookmarks