I am collecting priorities from various teams, via a dropdown with L, M, H values. How can I determine a "global" priority for each item, which would be the "highest" value selected between the teams? For example, if 2 teams have M and 1 has H then the global would be H. I could create helper columns that assign a value based on the priority chosen and then do the Max function but I wonder if there is an easier way.