I have multiple enum columns they all have these options:
I have a result column below these enums.
I want it to return the highest of these columns.
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.