Conditional Ranking? RANKEQ based off Category
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?
Help Article Resources
Check out the Formula Handbook template!