The handoff list needs Electrical together and Facilities together, with each group’s earliest deadline first. Use two keys to keep both rules clear.
Make Team the first level
Create ID, Team, and Due date columns. Add F-04 / Facilities / November 12, E-06 / Electrical / November 13, F-09 / Facilities / November 10, and E-07 / Electrical / November 11, using real 2026 dates. Select the whole table and choose Data → Sort → Custom Sort in Ulet. Indicate the headers and set Team ascending, then Due date ascending as the second level.

Illustrated sort setup. Select the full records and indicate the header row.
Read across the boundary between teams
The order should be E-07, E-06, F-09, F-04. F-09 has the earliest date overall, but Facilities follows Electrical. If F-09 appears first, check the key order. Verify each ID still belongs to its original team and due date.

Illustrated group boundary. F-09 remains in Facilities despite its earlier date.



