How to get smallest, 2nd smallest value and 3rd smallest value
Hello,
I need to run a formula which return smallest, 2nd and 3rd smallest value for a criteria. Example like below, when I key in "Banana" in cell D1, the result in F2 to F4 will give me 100, 150 and 200. This formula does not work because Smartsheet do not support array formula. Anyone have alternative way to make it happen?
Best Answer
-
=small(collect(qty:qty,products:products,"Banana"),1)
=small(collect(qty:qty,products:products,"Banana"),2)
=small(collect(qty:qty,products:products,"Banana"),3)
Answers
-
=small(collect(qty:qty,products:products,"Banana"),1)
=small(collect(qty:qty,products:products,"Banana"),2)
=small(collect(qty:qty,products:products,"Banana"),3)
-
Hi, it works. Thanks so much for your valuable answer.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
