Master tables

icon picker
Coordinators

Coordinators
Coordinator
Location
Team
Assigned - This Week
Weekly Limit
Out of office?
0
00
31
Available
0
00
18
Available
0
00
3
Available
There are no rows in this table

This is how the |Automatic Assign| button on the Candidates Table works 👇


Next Up RC for Round 1:
@John Scrugham
Coordinators.Filter([Available?]).Sort(true, [Assigned This Week]).Coordinator.First()
Automatic Assign [Find Coordinator] Button on the Candidate Table
ModifyRows(thisRow, thisRow.Coordinator,

SwitchIf(

thisRow.[Interview Stage]=[Initial (Round 1)], [Next Up RC for Round 1],
Coordinators.Filter(thisRow.Location.contains(thisRow.Location) and [Available?]).Sort(true,[Assigned This Week]).Coordinator.First()
)
)






Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.