Kind of Lost Kind of Lost ·OR Tools ·Project Scheduler ·Excel template ·Google Sheets template ·Support

Google Sheets Gantt chart template — free, with dates that calculate

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 Sheets

Opens 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.

What is in the template

One file with six tabs:

How the dates are calculated

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.

Using it in Google Sheets: five steps

  1. Click Make a copy and confirm. The file lands in your Drive.
  2. On the tasks tab, set the project start date in the yellow cell at the top.
  3. Replace the sample tasks with yours: name, days, predecessors, and the resource and crew per day if you want the load panel to mean something. Yellow cells are the ones to edit; leave the rest alone.
  4. On the resources tab, enter how many of each resource you really have per day.
  5. Read the chart. Watch the Check column for ordering mistakes and the load panel for red days, then share the sheet with your team so everyone looks at the same dates.

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.

What Google Sheets can’t do

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:

Level and solve your plan, free

No signup. The solved start dates come back in the Start column; paste them into Sheets or keep the returned file.

Limits

If you are on Excel instead, or want the manual stacked-bar method, see how to make a Gantt chart in Excel.

Common questions

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.