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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!