Introduction to Project Management and Gantt Views

  • Updated

With Spreadsheet.com, you can quickly create interactive Gantt charts side-by-side with your spreadsheet data to visualize work schedules and relationships between tasks.

Gantt views add an interactive timeline to the right of your worksheet showing taskbars corresponding to each row in the table region. For example, in a Tasks worksheet, you can use a Gantt view to manage a project’s schedule and create task dependencies.

GanttViewScreenshot.png

Gantt views are great for project management, as they create a Gantt chart next to your worksheet to track task progress. More than this, the Gantt view itself lets you visualize dependent tasks, parent tasks, and the critical path to hit your project's deadline.

Topics in this article

Creating Gantt views

Gantt views can be created in any worksheet by clicking “+ New view” in the view selector dialog and choosing Gantt, or selecting "Create new Gantt view" from the View menu.

2021-11-15_12.07.19.gif

When the first Gantt view is created in a worksheet, Spreadsheet.com will guide you through enabling Project Management on that worksheet. Here you can configure which columns are used for task management, settings for working days and hours, and whether or not to enable task dependencies:

A Gantt toolbar above the chart provides quick ways to zoom in and out of the chart, along with additional features such as bar labels, and highlighting the critical path:

mceclip0.png

Taskbars can be moved and resized using the mouse, via the zoom level in the Gantt toolbar, the zoom in and zoom out options in the toolbar, and can be widened or narrowed with the Gantt slider.

mceclip1.png

 

Project Management Settings

You can return to and modify the project management settings of a Gantt chart in the project management menu.

mceclip2.png

From the Project Management menu, you can adjust which columns are used for a task's start date, end date, user, duration, status, and more. You can also account for days off, start times, and set up dependencies between tasks.

mceclip3.png

Note: Columns selected for project management must remain the data type needed for project management. For instance, you cannot change an end date column to the text data type.

For more, see our full suite of views, including Kaban views and Forms.