Display name based on maximum value
Options
SkiPatrolScott
✭✭✭✭
I have a field of Patrollers, they are using a form to enter interactions with customers. In my sheet I have been able to create a summary report that counts the various Interactions by Patroller breaking out (Guest Assist, Violation, Slow Zone), cant get the sheet to Sort my count... But what I am looking for, and it would i guess be in the Sheet Summary, is the Partroller who is currently leading?
So if Joe has 10 Violations (the most Violations), I want 'joe" to display, but if Nancy issues more violations and passes Joe, I want "Nancy" to display.
Any ideas?
Answers
-
Found the answer , search 1st 2nd 3rd rank.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!