Employee Assignment Tracker Spreadsheet
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
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