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

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

Lucas Rayala

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.