Display name based on maximum value


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!