Product updates: Gantt Views and Project Management
co-founder & CEO
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.
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:
Automations & Integrations Ability to define automations in a visual workflow designer that run based on changes in worksheet data, without complicated scripting. For example, move, update, or create a new row in another spreadsheet, trigger a notification, an email, a Slack or MS Teams message, and more. We’re combining ready to go automation recipes with integration connectors to provide fast and easy starting points for building custom application behavior without writing code.
Public Sharing and Embedding We’ll soon be adding the ability to embed a workbook in an external site or third party application, such as a blog, website, or SaaS app. This will include the ability to share a public read only link to the workbook that does not require a user to have a Spreadsheet.com account to view it.