Basic Gantt View

Gantt View is one of the four ways to view your sheet in Smartsheet and offers a visual timeline of your work. Gantt charts are a staple in traditional waterfall project management but can be used anytime you want a visual representation of your schedule and the relationships between tasks.

In order to use Gantt View, you must have at least two Date columns in your sheet: a start date and an end date.

Review the basics of setting up your Gantt View.

Create and Work with a Gantt Chart

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.

TIP: If you are working with a report, see the article about how to add a Gantt chart to a report.

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


cropped-gantt

A Gantt chart also allows you to do the following:


Add a Gantt Chart 

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:

  1. Ensure your sheet contains at least two date columns, one representing the Start date of tasks and one representing the End date.

    These columns are required to add a Gantt chart to the sheet because the length of each task bar is based on the span of time between the given dates.
     
  2. Select the Gantt View button in the toolbar to display your tasks in a timeline view based on their Start and Finish dates.
    Views on the toolbar

    The chart will appear to the right of your columns and a divider splits the screen between grid columns and the Gantt chart. You can drag this divider right or left to widen the display of either section.
     
  3. Click the Project Settings icon  in the Gantt chart header to ensure the Gantt chart is using the correct columns for start and end date.

Adjust the Timeline Display

Across the top of the Gantt chart, an adjustable Primary and Secondary Timeline allows you to display your tasks using different units of time.

zoom

Click Zoom In or Zoom Out to toggle the different timeline displays.

Adjust the Project Settings

Click the gear icon gantt-settings to access the Project Settings for the sheet.

In the Project Settings form, you can: 

  • Enable Dependencies for automatic task duration calculation
  • Adjust the Primary and Secondary Timeline Displays
  • Configure non-working days and holidays

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:

Display Hierarchy

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.

Apply Color to the Gantt Bars

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.

Follow step-by-step instructions to adjust your timeline.

Adjust the Gantt Chart Timeline

The Gantt chart has 4 timeline zoom levels: quarter, month, week and day. Anyone with access to the sheet can quickly change the timeline zoom level by clicking the Zoom In or Zoom Out icons in the Gantt Chart header:

While anyone can use the Zoom in/out icons to adjust their own view, changes made by Viewers and Editors won't affect other collaborators or be displayed in an export. Only the sheet owner and collaborators with Admin access can make changes to the exported timeline.

NOTE: In the Gantt chart of a Report, all collaborators except Viewers are able to save changes to the Gantt chart timeline, and these changes will be reflected in an export.

The sheet owner and shared collaborators with Admin access can further configure and customize the Gantt chart's Primary and Secondary Headers by modifying the Timeline Display found in the sheet's Project Settings.