Kind of Lost
·OR Tools
·Project Scheduler
·Excel template
·Google Sheets template
·Support
This is a Gantt chart template for Google Sheets that works out its own dates. You type each task, how many working days it takes and which tasks must finish first. The start and finish dates are calculated, and the bars are drawn by the sheet itself, so when one task slips the rest of the chart moves with it. Underneath the chart, a daily crew panel turns red on any day your plan needs more people than you have.
Make a copy in Google SheetsOpens Google’s “Make a copy” prompt, so you need to be signed in to a Google account. The copy is yours to edit; nothing is sent to me. Prefer a file? Download the .xlsx version.
One file with six tabs:
Start is a formula, not something you type. A task with no predecessor starts on the project start date. A task with predecessors starts on the next working day after the latest of their finish dates. Finish is the start plus the task’s days, counted in working days.
With the default setting of 5 working days a week, weekends are skipped and shaded in the grid, so a five-day task that starts on a Thursday does not claim to end on a Saturday. Change WorkDaysPerWeek on the parameters tab to 7 if you work straight through. The bars are not drawings: they are cells that fill when a day falls between a task’s start and finish, so they stay correct when the dates change.
The Predecessors column takes task IDs separated by commas, so 6,7
means “wait for both 6 and 7”. The template’s formulas use
finish-to-start links. If you list a task above one it depends on, the Check
column tells you.
To fix a task on a date, put an x in its Pin column and type the
date over the Start cell. Everything else still calculates around it.
Sharing is where Sheets beats a workbook emailed around: one live file, edited from a phone on site, with the same dates for everyone. There is a longer write-up of what carries over between Excel and Sheets in Gantt Chart in Google Sheets: What Actually Ports.
The sheet draws the plan you describe. The red days show where you need more people than you have, but no spreadsheet formula can fix them, because choosing the best schedule under a crew limit is an NP-hard problem that needs a solver. That is the job of the free project scheduler at gantt.kindoflost.com. Download your sheet as .xlsx (File → Download → Microsoft Excel), upload it, and it hands the file back with:
No signup. The solved start dates come back in the Start column; paste them into Sheets or keep the returned file.
If you are on Excel instead, or want the manual stacked-bar method, see how to make a Gantt chart in Excel.
Does Google Sheets have a built-in Gantt chart? Not as a template you fill in with dependencies. This file builds the chart from cell formatting, which keeps it working when dates change.
Is it really free? Yes. No email and no signup.
Can I use it with MS Project? The scheduler exports MS Project XML, so you can plan here, solve there and open the result in Project.