Initial value based on multiple enum options from previous columns

Hi,

I have multiple enum columns they all have these options:
Extreme,High,Medium,Low

I have a result column below these enums.
I want it to return the highest of these columns.

For example
all enums are low, result = low
one enum is high the rest are medium, result = high

How could I achieve this? I thought of doing multiple if statements but from what I can see that would end up being huge.

IFS(
    IN("Extreme", LIST([column1], [column2], ...)), "Extreme",
    IN("High", LIST([column1], [column2], ...)), "High",
    IN("Medium", LIST([column1], [column2], ...)), "Medium",
    TRUE, "Low"
)

Swap [column1], [column2], ... with whatever and however many columns you have. If I remember correctly, IFS() will stop at the first true item it finds, so we start with the option that allows us to stop the soonest.

5 Likes

Thank you @Bahbus

Worked perfectly!

2 Likes