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!
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.
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
Awesome, really appreciate you implementing this John!
All the best!
Indeed! Very impressed John. You seem to be taking strides forward this year?
RichardR
SBP
John...still haven't seen this available in the product release notes. What is the ETA for these making it into smartsheet formula engine?
