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.
ProjectSheet can be installed from the G Suite 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 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.