Google Add-on for Sheets
This free add-on helps to create and modify a project schedule in a Google spreadsheet fast and accurately using a WBS work breakdown structure of tasks and start and finish dates per task. The ProjectSheet script calculates a Gantt chart from the schedule for the weeks set in the sidebar. During project execution optional color indications in the schedule table or Gantt chart give alerts for progress and delay.
❝ 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. ❞
ProjectSheet can be installed from the Google Workspace Marketplace and can then be added to an empty Google spreadsheet from its Add-ons menu. At first a table with columns and a Gantt chart are added to the spreadsheet, then the sidebar appears with functions. Tasks are entered in the table rows where they can be modified with help of the sidebar.
Next to the Free version the Pro version has additional functionality :
|enter WBS task breakdown||✓||✓|
|enter task start and finish dates||✓||✓|
|Gantt bar chart with multiple scales||✓||✓|
|progress indication with colors||✓||✓|
|shift scheduled dates||✓||✓|
|project summary sheet||✓||✓|
|custom columns and cell formules||✓||✓|
|finish date based on task duration||✓|
|chaining of consecutive tasks||✓|
|set working days||✓|
|free 10-day trial||✓|
|buy Pro in-app with PayPal||✓|
|price per account per year incl. VAT||€ 15|
|price per domain per year incl. VAT||€ 75|
A Google Sheets spreadsheet has inherent advantages :
- online access to files, always and everywhere
- show schedule to stakeholders by sharing the file for viewing (without ProjectSheet)
- real-time team work by sharing the file for editing (same ProjectSheet version)
- information exchange with Excel, download to pdf, etc.