Determine the "priority" based on alphanumeric values in other columns

KimTDSYN

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.

Paul Newcome

Are you able to provide a screenshot for context?

KimTDSYN

I want to "automate" the value in the blue column based on what the next 3 columns are set at.

Paul Newcome

Try this:

=IF(COUNTIFS([Priority-Ops]@row:[Priority-VBM]@row, @cell = "High") > 0, "High", IF(COUNTIFS([Priority-Ops]@row:[Priority-VBM]@row, @cell = "Medium") > 0, "Medium", "Low"))

KimTDSYN

Thank you but I don't think that'll work. My image is only showing one value but there will be one in each column so if one column is High and one is medium then both will be >0.

I think it'll be easier to manually assign.

Paul Newcome

But nested IFs stop on the firs true value. If there is at least one "High", it will output "High" and stop evaluating. Try inserting the formula and giving it a try.

KimTDSYN

That works! Thanks.

Paul Newcome

Happy to help. 👍️