Create and modify a project planning schedule with WBS work breakdown and Gantt time chart in one sheet.
Listing updated:February 21, 2024
Works with:
1M+
Overview
ProjectSheet summarizes several aspects of project management in a spreadsheet, both textual and visual. The aspects which you need to manage depend on the type of project and on what you like to control, like end date, budget. You can add your own aspects as well.

In the free version of the add-on you create tasks with start and finish dates and keep track of the progress. The optional Pro version adds calculations for task duration, work hours, resources, costs and chaining of tasks. You can try the Pro version with a 10-days free trial. 

๐—ช๐—•๐—ฆ
The start of project planning is to decompose the project scope in a multi-level Work Breakdown Structure of tasks by indenting tasks, resulting in tasks and summary tasks. The summary tasks combine the information of its subtasks. Summary tasks can be collapsed/expanded for overview.

๐—Ÿ๐—ถ๐—ป๐—ธ๐—ถ๐—ป๐—ด ๐˜๐—ฎ๐˜€๐—ธ๐˜€ (๐—ฃ๐—ฟ๐—ผ)
Tasks can be executed in a sequential order by chaining them as a waterfall. The start and finish dates are (re)calculated taking task duration, weekends and holidays into account.

๐—š๐—ฎ๐—ป๐˜๐˜ ๐—ฐ๐—ต๐—ฎ๐—ฟ๐˜
The Gantt chart shows the start and finish dates of a task as a bar against a time scale. The timescale can be changed in order to show the entire project or parts in more detail. Milestone tasks can be added to divide the project scope in phases with decision points in between.

๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€ (๐—ฃ๐—ฟ๐—ผ)
Resources are shared between all tasks by assigning them as needed. The costs per (summary) task and work type resource are calculated based on the hourly rate of the resource and the work hours per task. The work hours can be linked to the duration of the task.

๐—ฃ๐—ฟ๐—ผ๐—ด๐—ฟ๐—ฒ๐˜€๐˜€
When executing the project you track it by stating the progress percentage per task. The Gantt bar shows the progress visually. Options for progress indication give color alerts in text or Gantt chart for progress and delay.

๐—ฌ๐—ผ๐˜‚๐—ง๐˜‚๐—ฏ๐—ฒ ๐—ฒ๐˜…๐—ฎ๐—บ๐—ฝ๐—น๐—ฒ ๐˜ƒ๐—ถ๐—ฑ๐—ฒ๐—ผ๐˜€
See the YouTube video for the free WBS breakdown, Gantt chart and progress features and the ProjectSheet channel for Linking tasks and Assigning resources.
Additional information
PricingNot available
Developer
Non-trader
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
smor school
January 8, 2024
want
Is this review helpful?
Yes
No
Profile Picture
Christy Tucker
January 13, 2021
I use this regularly to share project plans with clients. It takes a little bit to learn, especially if you haven't used this kind of project management tool before, but it's easy for clients to understand the actual plans. The Pro version is a great value for the price. For me, it's worth paying for just to be able to chain dates together and have dates automatically recalculate when one preceding task slips.
Is this review helpful?
Yes
No
Profile Picture
Cassie Andrews
July 13, 2021
This looks to be a great product however after entering data, the dates and days continuously either disappear or change again and again and again... If there was a fix I'd happily use this product but as it stands it is unusable.
Is this review helpful?
Yes
No
Profile Picture
A User of ProjectSheet planning
April 9, 2020
A lot of the features that show up in the photos of this are NOT available, even in the pro version. I'm disappointed and feel misled.
Is this review helpful?
Yes
No
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
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
Ron Jansen
January 4, 2021
Pointless. All I see under Add-ons after installation is 1 item: 5 lines of useless help text
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
Samuel Bell
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
Jane Looi
January 24, 2021
App works with SHEETS , great!
Is this review helpful?
Yes
No
1-10 of 38
Search
Clear search
Close search
Google apps
Main menu