Compare Values of 5 columns with 6th

[Anonymous]

Hello all,

I have been looking through other threads but was unable to find a solution to my probelm. Here is what I am trying to do:

I have the following table:

Status	Overall KPI	KPI1	KPI2	KPI3	KPI4	KPI5
Yellow	Red	Green	Green	Green	Green	Green

I want to add a column that show me "correct" "incorrect" for

If at least one of KPI1-5 is red, then overall KPI is red,

If at least one of KPI1-5 is yellow, then overall KPI is yellow,

If Overall KPI is Green , then KPI1-5 are green

I feel like this should be simple but my brain does not let me find a solution at the moment.

[Anonymous · Accepted solution]

[Blebleble KPI] =
var __kpis =
    {[KPI1], [KPI2], [KPI3], [KPI4], [KPI5]}
return
    switch( true(),
        "Red" in __kpis,
            "Red",
        "Yellow" in __kpis,
            "Yellow",
        "Green"
    )

[Anonymous]

Thank you! This works great as now I can compare this new column with the new column