Help & Support
Send Feedback
ProjectSheet planning
Create and modify a planning schedule for project management in a spreadsheet with WBS work breakdown and Gantt time chart.
152,777 users
Works with
This free add-on helps you to create and modify a project schedule in a spreadsheet fast and accurately using a WBS work breakdown structure of tasks and start and finish dates per task. The Gantt chart can be set to show the project schedule for the range of weeks you like. During project execution, options for progress indication give color alerts in the schedule or Gantt for progress and delay. The add-on is available in several languages or a language can be requested.

The in-app PRO version adds resource assignment, cost calculation, scheduling with task duration and chaining of tasks to ProjectSheet, which help you in calculating and selling your project. The scheduling takes weekends and holidays into account.

The add-on requires some basic knowledge of project management, like the meaning of the terms used in this description.

A Work Breakdown Structure gives an overview of the tasks which fulfill the project scope. This add-on helps you with:
- Increase/decrease the task level
- Create summary tasks and milestones
- Collapse/expand summary tasks

The generated Gantt chart gives an overview of the timing of the tasks:
- Shift part or entire schedule in time
- Shift start date of the Gantt chart
- Change scale of the Gantt chart
- Indicate today's date in the chart
- Start day of period can be set to Sunday or Monday

Progress tracking during project execution:
- Indicate progress per task as a percentage
- Summary tasks are calculated
- Color indication of progress status per task relative to current date

PRO version:

Resource assignment:
- Assign resources to task
- Both work (per hour) and material (per unit) resources
- Overall addition per resource in Resource sheet

Budget calculation:
- Each resource can have a cost rate per unit
- ProjectSheet calculates per task the cost based on its assigned resources
- Summary tasks calculate cost based on its sub-tasks
- ProjectSheet calculates per resource the cost based on all the tasks

Enter task duration:
- Finish date will follow start date and task duration
- Task duration will follow change in finish date
- Start day and length of working week can be adjusted per document
- Weekends and holidays will be skipped

Chain tasks:
- Subsequent tasks on the same WBS level can be linked like a waterfall
- Summary tasks on same WBS level can be chained
- Subtasks will follow summary task or can be set to a fixed date
A User of ProjectSheet planning
November 9, 2019
Good Product!!
Submit reply
A User of ProjectSheet planning
September 24, 2019
Thank you...
Submit reply
A User of ProjectSheet planning
September 17, 2019
Doesn't work. Cannot be uninstalled.
Submit reply
A User of ProjectSheet planning
May 11, 2019
Did not have a critical path functionality that was what I was googling when this turned up in the results.
Submit reply
A User of ProjectSheet planning
December 31, 2018
Dates change randomly (or so it appears) in start and stop dates. It has no utility given the documentation and the lack of clarity in how things are linked
Submit reply
A User of ProjectSheet planning
November 23, 2018
It is a good app for simple and medium planification
Submit reply
Diliana Karailieva
November 22, 2018
How can a project management tool not have a real Critical Path capability?... The dependency can only be the task above which is as good as useless for the job.... :'(
Submit reply
A User of ProjectSheet planning
October 23, 2018
it just work, but how can i change the look of progress bar?
Submit reply
A User of ProjectSheet planning
January 16, 2018
This app is perfect! very useful!
Submit reply
A User of ProjectSheet planning
December 23, 2017
So far this has been working amazingly well for me. I've played around with 10+ google project management templates and this template is much more useful than anything I have previously tried.
Submit reply
1-10 of 27
Additional information
Clear search
Close search
Google apps
Main menu