Rank Values By Group

Chrisjohn France Juguan

Does anyone here know how to rank values by group in smartsheet? In excel, it's done like this below.

Stefan

Hi @Chrisjohn France Juguan,

there are 2 RANK formulas available in Smartsheet.

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

and

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

Hope this get's you going.

Greetings

Stefan

Chrisjohn France Juguan

Hi Stefan!

Thank you for this! Would you know if Smartsheet has an equivalent formula for Sum Product?

Regards,

Cj

Stefan

Hi @Chrisjohn France Juguan ,

there are several SUM formulas available, including SUMIF etc.

Have a look into the catalogue:

https://help.smartsheet.com/functions

Greetings

Stefan

Kathryn Richards

Hi! @Chrisjohn France Juguan 

I think formula should suffice!

=RANKAVG([Record]@row, COLLECT([Record]:[Record], [Group]:[Group], =[Group]@row)

kr