Gantt Chart with Dependencies

When you switch your sheet or report to Gantt View, tasks appear as bars in a timeline. The duration, start, and finish dates of your project tasks are project sheet columns.

Apart from that, you can also track the following:

• View Dependencies and track the relationship between tasks.
• View your project's Critical Path.
• Display the % Complete of your tasks.
• Use hierarchy to create summary rows to organize your projects further.

Before you add a Gantt chart

Your sheet or report must have at least two Date columns representing your tasks' start and end dates.

A task bar's length represents the period between those dates. You need at least two Date columns; otherwise, you can’t switch to Gantt View.

The Gantt View doesn’t recognize Date columns with a Column Formula applied. If you need your dates to autofill rows, use the Cell Formula and Autofill features instead. You could also set up column formulas and use a report to display your Gantt chart.

Add a Gantt chart

• In the toolbar, select Gantt View to switch your view.

The chart appears to the right of your columns. There is also a divider that separates the grid columns from the Gantt chart.

You can widen the display of either section by hovering over the divider and dragging the divider to the right or left.

You can widen the display of either section by hovering over the divider and dragging the divider to the right or left.

Edit your Gantt chart

1. Right-select any column header in the Gantt chart and choose Project Settings.
2. Modify the Project Settings in each tab according to your project needs:
   • Dependency Settings
   • Timeline Display
   • Resource Management

The sheet's Owner and Admins can modify the sheet Project Settings.

Adjust the Gantt chart timeline

The Gantt chart has four timeline zoom levels: quarter, month, week, and day.

Use the Zoom In or Zoom Out icons to adjust the view to what you need. 

You can save changes to the Gantt chart timeline, which appears when exported. Only Viewers don’t have access to this option.

Suppose you’re a sheet Owner or Admin access. In that case, you can configure and customize the Gantt chart's Primary and Secondary headers by modifying the Timeline Display directly in the sheet's Project Settings.

Work with Gantts 

Here are some tips when working with Gantts:

• Use baselines to compare a project’s scheduled times against actual completion. 
• Select and drag the center of a taskbar to move the task to new start and end dates.
• Row hierarchies in Gantt charts organize rows into sections or phases based on their start and end dates. 

• If you use hierarchies and turn on Dependencies on the sheet, parent rows reflect a summary of their child rows. The parent row values are calculated automatically in the Duration, % Complete, Start Date and End date columns: 

  You can’t modify parent values. If dependencies are off, you can change the parent row information as needed. 

• Configure a % Complete column in the Project Settings dialog. Any time you enter a value in this column, it is indicated in the taskbar.
• Apply color to the task bars.