[Equation Help] Searching the highest value and returning associated name?
Hi all - hopefully a relatively straight forward question who's equation I can't quite figure out. Essentially, I'm looking for a way to find the highest value in a data set, return the associated name, and then have that name appear on a dashboard. For instance:
Name Number of Learning Hours |
John Doe | 20 |
Jane Smith | 40 |
George Washington | 30 |
I'd like to find a formula that returns Jane Smith. I presume I'd then use that formula in the Summary function of Smartsheet to then roll into a dashboard. But I'm stuck on the initial equation. Any advice?
Best Answer
-
=Index({Name Ref},Match(Max({Value Ref}),{Value Ref},0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
=Index({Name Ref},Match(Max({Value Ref}),{Value Ref},0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thanks for your help! It worked perfectly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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!