Formula -

Brent Nathan

Trying to wrap my ahead around a formula to accomplish determining the top 5 $value projects in a list.

I know in excel I could use the LARGE formula to accomplish this...how could I do something similar in Smartsheet?

Thanks community!

 

AJ_vf

I want to hop on here to ask the inverse of this question:

I would like to assign numeric rankings (1, 2, 3,...) to rows based on their values in specific columns. EG: if I sorted a column by descending values, I would like the highest value ranked 1, second highest 2, etc.

John Creason

Brent -

I saw your question today...  Good scenario.  I went ahead and implemented LARGE and SMALL in the Smartsheet formula engine.  It's too late to ship in the next release which went to code freeze yesterday - it should make the one after that.

Best,

John

Brent Nathan

Awesome, really appreciate you implementing this John!

All the best!

Richard Rymill SBP

Indeed! Very impressed John. You seem to be taking strides forward this year? 

RichardR

SBP 

 

Brent Nathan

John...still haven't seen this available in the product release notes. What is the ETA for these making it into smartsheet formula engine?