Max Function but with Text
Hello Smartsheet Community: I want the Overall column to look at Issue A, Issue B, Issue C and Issue D and return the highest level. The levels are No Deficiencies, Low, Medium and High. Is that possible with text? See screen shot.
I know I can do this if I made High = 3, Medium = 2, etc. and only had numeric values in the cell using the Max function; however, the people I'm working with need to see the text >.<
Help Article Resources
Check out the Formula Handbook template!