Archived 2017 Posts
Archived 2017 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula -
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!
Comments
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives