Employee Assignment Tracker Spreadsheet

Job ID: 39654226

Budget: $30 – $250 USD

I need a Microsoft Excel spreadsheet to track employee assignments based on their preferred schedules and designated teams.

Requirements:
- Color-coded formatting for quick identification of teams and roles
- Dynamic sorting and filtering (automatically update) by:
- Name
- Team
- Role
- Schedule preference
- Attendance status
- Space for:
- 50 employee entries
- 25 team leads
- 15 jobs
- Attendance reliability column with categories:
- Reliable
- New
- Intermittent

Ideal skills and experience:
- Proficient in Microsoft Excel
- Strong attention to detail
- Experience with dynamic filters and color-coded formatting