Recruitment Team Schedule: One Row per Interview
This team schedule is the interview list, not a staff rota. One row is one interview: the candidate, the opening, the interviewer, the date, and the start time. Two rows with the same interviewer and the same start time are a clash. A filter on the interviewer shows that person's slots. The sheet does not send the calendar invite. Elyx can lay out the columns on the names you paste. The trial lasts 7 days, with no card.
The Problem
Interview times sit in email threads. You cannot see, on one list, who is already booked at that hour. One row per interview makes the clash visible: same person, same start time. You still send the invite yourself.
Benefits
One row is one interview, not one shift.
You type the candidate, the interviewer, the date, and the start time.
The same interviewer at the same start time is a clash you can filter.
A missing time stays blank.
The sheet does not send the invite.
Step-by-Step Tutorial
Create the table structure
Open a new Excel workbook and set up the main columns for your team schedule. Create headers for: Date, Team Member, Position, Status, Tasks, and Notes. Format the header row with bold text and a background color to make it stand out. This structure will serve as the foundation for tracking your recruitment team's daily activities.
Use Ctrl+T to convert your data range into a structured table, which enables automatic formatting and easier formula management
Add date column with automatic population
In the Date column, enter the start date manually (e.g., 01/15/2024) and use auto-fill to generate consecutive dates for your scheduling period. This ensures consistency and saves time when creating schedules for multiple weeks or months.
Select the first date cell, then drag the fill handle down while holding Shift to quickly populate dates for an entire month
Create a Status dropdown list
Set up data validation for the Status column to standardize how team members report their availability. Create a dropdown list with options like 'Available', 'On Leave', 'Training', 'Client Meeting', and 'Remote'. This ensures consistent data entry and makes scheduling decisions easier.
Go to Data > Data Validation > List, and enter your status options separated by commas for a clean dropdown menu
Add IF formula to highlight unavailable days
Create a helper column that automatically flags when team members are unavailable for interviews or client meetings. Use an IF formula to check if the Status is 'On Leave' or 'Training' and display a warning indicator. This helps you quickly identify scheduling conflicts.
=IF(OR(C2="On Leave",C2="Training"),"⚠ NOT AVAILABLE","Available")Use conditional formatting with this formula to highlight unavailable cells in red for better visual clarity
Count team members available per day with COUNTIF
Add a summary section below your schedule to track how many team members are available each day. Use COUNTIF to count cells in the Status column that contain 'Available'. This metric helps you understand your team's capacity for conducting interviews on specific dates.
=COUNTIF(C2:C31,"Available")Place this summary in a separate section with labels like 'Total Available Today' to create a quick reference dashboard
Create TODAY formula for current date reference
Add a cell that displays today's date using the TODAY() function. This serves as a reference point to automatically highlight the current date in your schedule and helps identify overdue tasks or upcoming deadlines. Position this prominently at the top of your template.
=TODAY()Use conditional formatting to highlight rows where the Date equals TODAY() with a light blue background for easy identification
Build a conditional formatting rule for scheduling conflicts
Apply conditional formatting that automatically highlights rows where a team member is marked 'On Leave' or 'Training' but has tasks assigned. This prevents accidentally scheduling unavailable recruiters for interviews or client meetings, reducing scheduling errors.
=AND(OR(C2="On Leave",C2="Training"),D2<>"")Use a bright warning color (orange or red) for these conflicts so they're immediately noticeable during schedule planning
Add a weekly availability summary with COUNTIF
Create a summary table that counts how many days each team member is available during the week. This helps you understand individual capacity and plan recruitment activities accordingly. Use COUNTIF to count 'Available' status for each person across the week.
=COUNTIF($B$2:$B$31,G2)+COUNTIF($C$2:$C$31,"Available")Create this summary in a separate area (columns to the right) to keep your main schedule clean and focused
Set up conditional formatting for overdue tasks
Apply a formula-based conditional format that highlights tasks with dates before TODAY() that haven't been marked as completed. This ensures no recruitment deadlines slip through the cracks and helps your team stay accountable for time-sensitive activities like job posting deadlines or candidate follow-ups.
=AND(A2<TODAY(),E2<>"Completed")Use red background formatting for overdue items and consider adding a filter to quickly view all overdue tasks
Protect and finalize your template
Lock the header rows and formula cells to prevent accidental changes while allowing team members to edit only the Status, Tasks, and Notes columns. This maintains data integrity while giving your recruitment team flexibility to update their daily information. Add instructions at the top explaining how to use the template.
Use Format > Cells > Protection tab, then go to Tools > Protect Sheet to lock formulas while keeping data entry cells editable
Template Features
Interview Schedule Conflict Detection
Automatically flags overlapping interview time slots for the same recruiter, preventing double-booking and scheduling conflicts
=COUNTIFS($B$2:$B$100,B2,$C$2:$C$100,C2,$D$2:$D$100,D2)>1Candidate Pipeline Status Tracking
Tracks each candidate's progression stage (Screening, Interview, Offer, Hired) with automatic status updates linked to scheduled dates
=IF(D2="","Pending",IF(E2="","Scheduled","Completed"))Recruiter Workload Balance Dashboard
Calculates interview count per recruiter to ensure equitable workload distribution and identify capacity constraints
=COUNTIF($B$2:$B$100,B2)Automated Follow-up Reminders
Highlights interviews occurring within the next 48 hours, prompting timely candidate communication and preparation
=AND(D2<=TODAY()+2,D2>=TODAY(),D2<>"")Time-to-Hire Calculation
Automatically computes days between initial screening and offer acceptance to measure recruitment efficiency
=IF(AND(C2<>"",F2<>""),F2-C2,"")Department Hiring Quota Progress
Displays real-time percentage of open positions filled per department against monthly hiring targets
=COUNTIFS($A$2:$A$100,A2,$G$2:$G$100,"Hired")/VLOOKUP(A2,QuotaTable,2,0)Concrete Examples
Coordinating Multi-Round Interview Schedule
Sarah, a Recruitment Specialist at a tech startup, manages 12 candidates across 3 interview rounds (phone screen, technical, final). She needs to track which candidates are scheduled for which round, avoid double-bookings, and ensure interviewers are available.
Week 1: Phone screens with 8 candidates (Mon-Wed, 30-min slots); Week 2: Technical interviews with 5 candidates (Tue-Thu, 1-hour slots); Week 3: Final interviews with 3 candidates (Wed-Fri, 1.5-hour slots). Interviewers: John (available Mon/Wed/Fri), Maria (available Tue/Thu), David (available all days)
Result: A color-coded schedule showing each candidate's interview stage, date/time, assigned interviewer, and completion status. Prevents scheduling conflicts and provides a clear pipeline view for stakeholder updates.
Tracking Recruitment Metrics and Time-to-Hire
James, a Recruitment Specialist for a healthcare organization, needs to monitor recruitment efficiency across 4 open positions. He tracks application dates, interview dates, offer dates, and hire dates to calculate time-to-hire for each role.
Nurse position: Posted Jan 5, first interview Jan 15, offer made Feb 2, hired Feb 10 (36 days); Lab Technician: Posted Jan 8, first interview Jan 22, offer made Feb 5, hired Feb 12 (35 days); Administrative Assistant: Posted Jan 12, first interview Jan 25, offer made Feb 8, hired Feb 15 (34 days)
Result: A dashboard showing time-to-hire by position, average hiring cycle, conversion rates at each stage (applications to interviews, interviews to offers), and a timeline visualization. Enables data-driven process improvements and realistic timelines for future requisitions.
Managing Candidate Pipeline Across Departments
Lisa, a Recruitment Specialist at a manufacturing company, coordinates hiring for 6 departments simultaneously. She tracks candidate names, applied positions, current stage (application, screening, interview, offer, hired, rejected), department assignment, and salary bands.
30 active candidates distributed: 10 in application review, 8 in screening phase, 7 in interview stage, 3 with pending offers, 2 hired. Departments: Production (12 candidates), Quality (6), HR (4), Finance (5), Logistics (2), Safety (1)
Result: A summary dashboard showing pipeline distribution by stage and department, candidate status reports, bottleneck identification (which stage has the most candidates stuck), and forecasted hiring dates. Enables better resource allocation and prevents candidate fallthrough.
Pro Tips
Conditional Formatting for Interview Status Pipeline
Use color-coded conditional formatting to instantly visualize candidate progression. Apply traffic light rules (Green = Offer, Yellow = Interview Scheduled, Red = On Hold, Gray = Rejected) to your status column. This enables quick visual scanning of your pipeline without opening individual records. Use Format > Conditional Formatting > Color Scales or Icon Sets to automate this.
=IF(B2="Offer",TRUE,IF(B2="Interview",TRUE,IF(B2="On Hold",TRUE,FALSE)))Dynamic Team Capacity Analysis with SUMIF
Create a summary dashboard showing how many open positions each team member is recruiting for. Use SUMIF to automatically count assigned positions by recruiter name. This prevents overallocation and ensures balanced workload distribution. Update in real-time as you assign candidates.
=SUMIF(Team_Schedule!$D:$D,A2,Team_Schedule!$G:$G)Timeline Alerts with Conditional Flags
Flag candidates whose interviews are overdue or approaching offer deadline. Create a helper column calculating days elapsed since last action, then highlight rows exceeding your SLA (e.g., 5 business days). Use TODAY() function to auto-update without manual intervention.
=IF(TODAY()-E2>5,"OVERDUE",IF(TODAY()-E2>3,"URGENT",""))Quick Pivot Table for Recruitment Metrics
Build a Pivot Table (Insert > Pivot Table) to instantly analyze hiring velocity by department, source channel, or recruiter performance. Drag fields to rows/columns/values to generate reports without formulas. Refresh with Ctrl+Alt+F5 when data updates. This transforms raw scheduling data into actionable KPIs in seconds.