Welcome!

Ranking column in SMARTSHEET

Hi all ,

I am managing a contest between 10 candidates , and I would like to establish a ranking acoording to the " total points " obtained ( yellow column ) .

The ranking will be progressive as the candidates receive points incrementally .

Any suggestion ?

Classement avec SMARTSHEET.PNG

Find more posts tagged with

Comments

L_123

=if([Total Points / 100]@row = max([Total Points / 100]$2:[Total Points / 100]$11), 1,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,2),2,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,3),3,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,4),4,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,5),5,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,6),6,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,7),7,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,8),8,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,9),9,if([Total Points / 100]@row = large([Total Points / 100]$2:[Total Points / 100]$11,10),10,""

The above should post a 1 - 10 based on the relative value of the integer in the corresponding row. If you add a column, add this to the second row of said column, and drag it down 10 rows I believe it will give you what you want.

L_123

That or you can do it the smart way and use the new formulas I always forget about.

https://help.smartsheet.com/function/rankeq

ALAIN-STEPHANE

Thank you very much !

Sign in to join the conversation!

Quick Links

Trending discussions

Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
Selected Data Cannot be charted
It does not matter which data I select, I am getting the error of Selected data cannot be charted. I even tried reusing a report that is producing a chart on a different dashboard, but I am unable to create new charts in a dashboard. Anyone have any ideas as to why?
Upgrade user mismatch
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.