Project Management | Google Sheets Template

Run your projects in one Google Sheets template: a task list, an automatic Gantt chart, a kanban board that fills itself, and a dashboard with deadlines, workload and project health.

WHAT'S INSIDE

- Dashboard: total tasks, done, overdue and % complete, tasks by status chart, workload per team member chart, upcoming deadlines for the next 14 days and every project's health and progress

- Tasks: project, task, owner, priority, status (to do, in progress, review, done, blocked), start, due, % complete with a progress bar, days left and an overdue flag

- Gantt: a 26-week timeline where each task's bar lights up from start to due date, colour coded for done, overdue and blocked, with this week highlighted

- Board: a kanban view with one column per status. Change a task's status and its card moves on its own

- Projects: owner, start and end dates, status, task counts, % complete, health (on track, at risk, complete), budget, spent and left

- Setup: company or team name, currency, timeline start date, team members and roles, statuses and priorities

- Start Here tab with simple instructions

TWO VERSIONS

You get a sample version filled with example projects so you can see how everything works, and a blank version ready for your own team.

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link in the PDF. Google asks you to make a copy, which is saved to your own Google Drive. Share it with your team.

3. Add your team and projects on the Setup and Projects tabs, then add your tasks.

GOOD TO KNOW

- The Gantt and Board show up to 120 and 60 tasks per view

- Works in Google Sheets on computer, tablet and phone (editing is easiest on a computer)

- A free Google account is needed

- Not made for Excel or Numbers

- This is a digital product. No physical item will be shipped

- For use in your own business or team. Please do not share or resell the template

- Because this is a digital download, returns are not accepted. If you have any problem, email me and I will be happy to help