Gantt Views and Project Management
Now you can quickly create interactive Gantt charts side-by-side with your spreadsheet data to visualize work schedules and relationships between tasks.
Video: Introduction to Gantt Views and Project Management (5 mins):
Gantt views add an interactive timeline to the right of your worksheet showing task bars corresponding to each row in the table region. For example, in a worksheet of Tasks you can use a Gantt view to visually manage a project’s schedule and create task dependencies.
Gantt views can be created in any worksheet by clicking “+ New view” in the view selector dialog, and choosing Gantt:
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:
Once Project Management is enabled, the assigned columns inherit special behavior. For example, Start Date, End Date, and Duration values automatically recompute when adjusted in the worksheet or Gantt chart, and data in these columns automatically rolls up from child rows to parent rows in hierarchies.
Task bars can be moved and resized using the mouse, and dependencies can be established between tasks by dragging connections between task bar antennae, as shown here:
A Gantt toolbar above the chart provides quick ways to zoom in and out of the chart, along with additional features such as highlighting the critical path:
We’re looking forward to your feedback on this new set of features.
Gantt beta limitations and future work
- Tasks with sub-day durations (e.g… 4hr, 6hr, etc.) and fractional day durations (1.5d) do not render precisely in the chart yet. Right now they appear as having full day lengths.
- Dependencies are not yet enforced for parent-level tasks in hierarchies.
- Project Management settings do not yet support holidays.
- Working day start time and Length of day settings are not yet customizable.
We’ll be addressing each of these limitations in future updates.