Find Top Value projects and Sort
Hi , Can you please help.
I have the "data set" which Project and Revenue.
The requirement is
a. To automate where top 3 projects by revenue can get populate and
b. then get sorted by revenue value
At this time, I am typing the project names manually and then doing Index(Collect) the Revenue by project name
Answers
-
I have something similar set up with my own sheet! What I did was add a helper column to Rank by the number column, e.g:
=RANKEQ(Revenue@row, Revenue:Revenue, 0)
See: RANKEQ Function
Then you can use a Report to Filter by 1, 2, and 3 from that Rank Column, and Sort by that number so that it's in the correct order.
This way as you make changes to the Revenue number column, the Rank will automatically adjust and the Report will only show the top 3. Let me know if this makes sense and works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!