Conditional Ranking? RANKEQ based off Category
Options
Hello Fellow Smartsheet Users,
I am having trouble putting together RANKEQ formula that ranks rows in my sheet by Total Aggregate Value, but only based off the Department. I would like to return top 5 aggregate values per each Department listed. Can anyone please assist?
Answers
-
Try using a COLLECT function in the range portion of the RANKQ function.
=RANKQ(number, COLLECT(Total:Total, Department:Department, @cell = Department@row), optional_order)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!