Learning Track
This Help Article appears in the Level 1: Get Started learning track. Get the most out of this learning track by starting at the beginning.
This Help Article appears in the Level 1: Get Started learning track. Get the most out of this learning track by starting at the beginning.
This Help Article appears in the Level 3: Advanced Users learning track. Get the most out of this learning track by starting at the beginning.
The Owner and Admins can modify the sheet project settings.
Display tasks in your sheets and reports as bars in a timeline with a Gantt chart. Get a picture of the duration, as well as the start and finish date of your project's tasks Gantt View.
You can view any sheet or report that contains at least two date columns in Gantt View. (For more information on Date columns, see the Column Types article in the Help Center.)
A Gantt chart also allows you to do the following:
You can add a Gantt chart to any existing sheet and optionally enable the dependencies features to create automation between project sheet columns.
To add a Gantt chart:
Across the top of the Gantt chart, an adjustable Primary and Secondary Timeline allows you to display your tasks using different units of time.
Click Zoom In or Zoom Out to toggle the different timeline displays.
Click the gear icon to access the Project Settings for the sheet.
In the Project Settings form, you can:
Find out more about modifying project settings in the Modify Project Settings article.
If you've configured a % Complete column in Project Settings, any time a value is entered in this column its also visually indicated in the Gantt bar for the task:
In the sheet's Primary Column, you can indent rows to create a hierarchical relationship to organize rows into sections that you can expand or collapse. Child rows display as individual task bars in the Gantt chart based on their start and end dates.
If dependencies are enabled on the sheet, parent rows reflect a summary of their child rows. The parent row values are calculated automatically in the duration, start and end date, and % complete columns and can't be modified. If dependencies aren't enabled, you can change the parent row information as needed.
NOTE: Row hierarchy isn't displayed in a report.
Change the color of a Gantt bar color in a sheet by right-clicking on the bar and selecting Color Settings.
NOTE: Task bar colors may change automatically if your sheet has Conditional Formatting rules set up. Check out our Help Center article on Conditional Formatting for more information.