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.
Solved! Go to Solution.
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.
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.
Thank you @Bahbus
Worked perfectly!
User | Count |
---|---|
46 | |
29 | |
24 | |
22 | |
13 |