Working with Gantt Charts

Display tasks in your sheets and reports visually 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 also use project management features, such as (the following links redirect to other articles in the Help Center):

  • Using Dependencies to track the relationship between tasks.
  • Tracking the critical path of your project.
  • Displaying the % complete of your tasks.
  • Using hierarchy to create summary rows for further organization of your projects.

You can view any sheet or report that contains at least two date columns in Gantt View. More information on Date columns can be found in the Column Types article in the Help Center.


 Jump to video demonstration: Gantt Chart View


Creating a Gantt Chart

Here's how you can get started on creating a Gantt chart in Smartsheet (the following links redirect to other articles in the Help Center):

Select the Gantt View button in the left toolbar to display your tasks in a timeline view based on their Start and Finish dates. In Gantt View, 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.

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 just below the timeline to toggle through different timeline displays.

Adjusting the Project Settings

Click the gear icon in the Gantt chart's header to access the sheet's Project Settings.

In the Project Settings form, you can: 

  • Enable Dependencies for automatic task duration calculation. Details on this functionality are in the Help Center article on Enabling Dependencies.
  • Adjust the Primary and Secondary Timeline Displays—find out more about this in the Modifying Project Settings article.
  • Configure non-working days and holidays. Details on this can be found here

Displaying Hierarchy in Gantt Charts

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.

Applying 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. Task bar colors can also change automatically based on rules using Conditional Formatting. Check out our Help Center article on Conditional Formatting for more information.

In a report, background color of Gantt bars reflect the formatting applied within the associated sheet. Make changes to the bar colors from the sheets to also update the report. For more information, check out the Creating Reports article in the Help Center.

If you've configured a % Complete column in your Project Settings, any time a value is entered to this column it's also visually indicated in the Gantt bar for the task:

Printing a Gantt Chart

You can print your Gantt chart by clicking the Print icon in the left toolbar. For more information on the printing process, see the Printing from Smartsheet article in the Help Center.

Check out more tips on printing in the Smartsheet Blog:How to Print Your Gantt Chart


Video Demos

For an instructional demonstration on creating a basic Gantt chart, please review the following video walk-through:

For more advanced Gantt chart functionality, please see the video below:

If you don't have access to YouTube, click here to watch the video.

Check out the Smartsheet Blog for details on creating a master Gantt Chart: How to Use Cell Linking to Create a Master Gantt Chart

Back to Top