Google Sheet: Weekly Time Tracker & Project Manager
Budget: $30 – $250 AUD
I'm looking for a freelancer with expertise in Google Sheets to design an efficient and user-friendly weekly time tracker and project manager for my team.
Key Features:
- A dedicated tab listing tasks and projects, arranged by priority.
- A time tracking tab where team members can log their hours, tasks, and project details.
- A pie chart summarizing how work hours are allocated, specifically by task.
- Seamless integration for adding a new week or new projects.
- Conditional formatting that color codes based on priority, highlights overdue tasks, and bolds important tasks.
Essential Info on Time Tracking Tab:
- Date and hours worked
- Task description
- Sortable data for easy tracking
Ideal skills and experience include:
- Advanced Google Sheets proficiency
- Experience in project management tools
- Understanding of time tracking systems
- Knowledge of data visualization (pie charts)
- Familiarity with conditional formatting
I need a system that allows my team to efficiently track their time, tasks and project details, while also providing a visual representation of our work hours. Your design should be intuitive and easy to navigate, promoting seamless team collaboration.
Key Features:
- A dedicated tab listing tasks and projects, arranged by priority.
- A time tracking tab where team members can log their hours, tasks, and project details.
- A pie chart summarizing how work hours are allocated, specifically by task.
- Seamless integration for adding a new week or new projects.
- Conditional formatting that color codes based on priority, highlights overdue tasks, and bolds important tasks.
Essential Info on Time Tracking Tab:
- Date and hours worked
- Task description
- Sortable data for easy tracking
Ideal skills and experience include:
- Advanced Google Sheets proficiency
- Experience in project management tools
- Understanding of time tracking systems
- Knowledge of data visualization (pie charts)
- Familiarity with conditional formatting
I need a system that allows my team to efficiently track their time, tasks and project details, while also providing a visual representation of our work hours. Your design should be intuitive and easy to navigate, promoting seamless team collaboration.