MAX + COLLECT Formula Help

Options

Hello!

I am trying to create a formula that will find the largest % from the % cells in each row and then label it correctly. For example, if the largest % is Novice in the first row, I want the blank box column to note that the Overall Expertise Level is Novice. Please advise how to set up this formula. I think it is a combination of max and collect, but I am not sure how to format it.


Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!