App Icon
Create and modify a planning schedule for project management in a spreadsheet with WBS work breakdown and Gantt time chart.
Works with:
695,439
Overview
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
Additional information
Privacy policy
Terms of service
ProjectSheet planning will ask for the permissions shown below. Learn more
ProjectSheet planning will need access to your Google account
This will allow ProjectSheet planning to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of ProjectSheet planning
October 21, 2016
This is a great add-on. As a Google Sheets enthusiast who needs to use an intuitive project management tool, I must say it has worked very well for me so far. It's extremely versatile and powerful without being overly complicated and confusing. You can add your own customised columns with all the same function compatibility/ conditional formatting of the vanilla version of Google Sheets at the same time as using all the neat, and relatively simple, features of the add-on as well. Highly recommended.
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
November 12, 2015
I like the WBS feature of the template but every now and then the sheet will shift the row item names reside on without shifting the corresponding values on the same rows, creating an obscene mess to correct.
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
February 8, 2017
THIS IS SUCH AN AMAZING TOOL! I literally have ALL the Gantt Chart templates you can find in the Google Templates directory. This add-on beats them out by 1,000. Easy 5 Star rating. I'm not sure why this had low reviews in the past but do yourself a favor and grab this. It will make your life 1000x better. -- The only thing I wish this had is Hourly Estimations to be used in a burndown chart (feature request? - I'll find a way to get give it 6 stars :D Great job guys. Will be purchasing the pro version when my trial runs up.
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
October 24, 2016
This is a great add-on. I just have a comment which I did not like when I removed tasks or changed finish date: - The add-on did not update status / re-order tasks. I have to check button refresh or reload this page. If you guys can fix. Please do it.
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
December 16, 2015
This looks like a great template for project management. however, i am having a lot of issues. After inputting columns worth of information they all seem to suddenly disappear. Not sure what is happening. I would love some feedback and help to resolve this issue.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
November 30, 2015
Just started using it, very intuitive, like it a lot.
Is this review helpful?
Yes
No
Profile Picture
Tom Karlo
March 20, 2014
Spent an hour putting my project info into this, saved it, and now when I open it and try to manage the schedule I get the error 'Cannot call method "getValues" of undefined.' with no ability to recover.
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
April 6, 2016
doesn't load, just opens a new blank work sheet
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
April 23, 2017
I had some problem with time setting, but they found the problem really fast after I Email to them. I Really like this app. Thanks. Nice app.
Is this review helpful?
Yes
No
1-10 of 40
Search
Clear search
Close search
Google apps
Main menu