RANKEQ is not ranking sequentially


With this formula couldn't able to rank the values sequentially

=RANKEQ(Values@row, Values:Values, 0)

Expecting All 100 to Rank 1

And 80 to Rank 2

and 70 to Rank 3.

Could you please help me out here.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!