Sort CMS Collection by Reference Link

Is there a way to sort a collection by a Reference Link. I have created a collection called "Departments". In the departments, I have listed out each team (ex. Engineering, Marketing, Sales, etc...). Then I have created a Reference Link to that collection in the TEAM collection where the person's name, title, and department lives.

Each Department is numbered (01-Engineering, 02-Marketing, 03-Sales, etc...) so when I sort by that Reference Link it will sort them from A-Z or lowest to highest. The last thing I'm adding a number field in the TEAM collection so I can number the team members in a department from 1-10 so I can sort by department then sort by the number based on where they are in their department, (ex. team lead, team member, entry level, etc..). Any thoughts?

EXAMPLE OF MY END GOAL:
----------------------------------------------------

01-EXECUTIVE TEAM
 1-Joe (CEO)
 2-Kevin (CTO)
 3-Mary (VP)
 4-Corey (Director)
 5-Andrea

02-ENGINEERING
 1-Tim (Lead)
 2-Dave
 3-Rachael
 4-Calvin (Jr Engineer)

03-MARKETING
 1-Rory (Sr. Manager)
 2-Andrew (Lead)
 3-Heather

and so on... So I'm sorting twice, first by department, then by order in that department through the entire team. Appreciate any feedback.


  • Continuous Composites
  • Apr 10 2019