My, my, my, my
Timeline hits me, so hard
makes me say "Yo Kanban board
Thank you, but it's time to ride
in a sheet with a Gantt chart side-by-side"
We're doing the Hammer dance here as we announce the beta release of Gantt Views in Spreadsheet.com. Now you can quickly create interactive Gantt charts side-by-side with your spreadsheet data to visualize work schedules and relationships between tasks.Watch an overview video (4.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.
.png)
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, along with additional features such as highlighting the project's critical path:
Read more in our Quick Start guide to Gantt views: Introduction to Gantt Views and Project Management.
A few features we're busy working on now:
As usual, whenever we release updates to the product we share more details of new features, enhancements, and fixes in the What’s New? section of the Spreadsheet.com Community.
