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!
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!