RANKEQ
i try to ranking the number column with some criteria with this formula:
=IF(AND(HAS([Product Category]:[Product Category]; "Google"); OR([Stage Category]@row = "Healthy"; [Stage Category]@row = "Stuck")); RANKEQ([Sum of Total Contract Value (converted)]@row; [Sum of Total Contract Value (converted)]:[Sum of Total Contract Value (converted)]; 0))
but when i check the top 30 ranking with filter, i just find this rank. please help:
Answers
-
You "IF" only prevent the RankEQ to write something in the column. But you rank all the row. It happens that 22,23 and 24 fit the "if" condition.
You could set a helper column that flags the rows you want to rank, and then rank on that column
[Helper column] : Checkbox
=IF(AND(HAS([Product Category]:[Product Category]; "Google"); OR([Stage Category]@row = "Healthy"; [Stage Category]@row = "Stuck")); 1; 0))
[Ranked TCV]:
=RANKEQ([Sum of Total Contract Value (converted)]@row;collect([Sum of Total Contract Value (converted)]:[Sum of Total Contract Value (converted)];[Helper column],=1))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!