Find a MAX value in row and return the Column name.

Options

I'm trying to find the max value between all the strength columns and have it return the column name of the max value. I've tried the following formula as suggested by AI and other articles I've found but I keep getting #UNPARSEABLE.

=INDEX([Behavioral - Strength]@row:[Respiratory - Strength]@row, MATCH(MAX([Behavioral - Strength]@row:[Respiratory - Strength]@row), ([Behavioral - Strength]@row:[Respiratory - Strength]@row),)))

Any help is greatly appreciated!

Tags:

Answers

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭
    Options

    Hi @ciera_wolinski, you can't pull the column name using a Smartsheet formula, not natively. You could create some workarounds (a hidden row with all the column names in it), but you also run into the problem that "Max" may be multiple columns, which makes it even more difficult. Do you know if max would be one or multiple columns?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!