Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Creating a leaderboard from a list of nominations

I have an intake sheet with a list of nomination names and a nomination date. This will be populated via a form so will be continually updating. From this sheet I need to create a leaderboard showing the top 3 nomination names.

I have created a helper column to count the times the name appears:

=COUNTIFS([Nominator Name]:[Nominator Name], @cell = [Nominator Name]@row)

I have created another sheet called Leaderboard to pull in the 'Leaderboard Positions' of 1, 2, 3.

I have used the below cross sheet formula to pull in the Nominator Name
=INDEX({Source Sheet | Name}, MATCH(LARGE({Source Sheet | Helper}, [Leaderboard Position]@row), {Source Sheet | Helper}, 0))

And for the count of Nominations, I have used =INDEX({Source Sheet | Helper}, MATCH([Nominator Name]@row, {Source Sheet | Name}, 0))

I have applied a column formula and expected it to work!

However, when I expand the positions to 15, this happens:

What simple logic am I missing?!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions