With Gantt Views and Project Management features, you can create interactive Gantt charts that live side-by-side with your spreadsheet data.
Gantt Views are a paid feature available on Standard, Premium, and Enterprise plans. To learn more about Spreadsheet.com’s paid plans, visit our Pricing page.
Spreadsheet.com’s Gantt Views and Project Management features give you more ways to plan, schedule, and visualize projects of any size. With support for task dependencies and constraints, you can build out an end-to-end project timeline with advanced scheduling logic found in most project management software.
What is a Gantt Chart?
A Gantt chart is a graphical representation of a timeline. Individual tasks are represented as taskbars laid out on a horizontal axis, with the length of each taskbar proportional to the length of a task. Compared to tasks listed as spreadsheet rows, Gantt charts help project managers better envision a project’s timeline.
By turning a task list into a Gantt chart, a list like this…
…becomes a timeline like this:
Gantt Views place one of these timelines side-by-side with your project task list.
How to Add a New Gantt View to Your Worksheet
- Click the View name or the Pin Views Sidebar button to open the Views sidebar
- From the Views sidebar, click the + Gantt button at the bottom
- Specify the name and access level of your new View
When you create a new Gantt View, Project Management settings will automatically be enabled in your workbook.
Exploring Gantt View and Project Management Features
Gantt Views and Project Management settings are packed with features to help you manage projects in Spreadsheet.com like a PM professional.
Dependencies and Constraints
Dependencies and constraints determine how multiple tasks within a project are scheduled and sequenced, in conjunction with task start and end dates. Dependencies describe relationships between tasks that must be started or completed in a specific order. Constraints are used to minimize the time between successive tasks or schedule tasks in such a way so as to not delay the project.
Spreadsheet.com supports four types of dependencies and eight types of constraints.
Task Hierarchies and Parent Cell Rollup
Task hierarchies can help you make distinctions between tasks and subtasks, or organize tasks into larger scopes of work. When you organize tasks into hierarchies with Project Management enabled, some fields in parent rows – like Start Date, End Date, and % Complete – automatically rollup information from their child rows.
Learn more about working with task hierarchies when Project Management is enabled.
Critical Path
A project’s critical path is the series of tasks that determines the duration of the project as a whole. Delays to activities on the critical path delay the project as a whole. Spreadsheet.com automatically calculates your project’s critical path and can highlight it on your Gantt View. Learn more about the critical path.
Learn More: Managing Projects with Gantt Views
Gantt Views and Project Management settings are some of the most powerful features in Spreadsheet.com. They can help you manage projects of any size, from planning small events to managing multi-million dollar construction projects. Learn more with these resources:
- “Introduction to Project Management and Gantt Views” – Learn more about working with Project Management and Gantt Views
- “Project Management Settings” – Learn how to fine-tune your workbook’s Project Management settings
- “Introduction to Dependencies” – Explore types of dependencies and learn when to use them
- “Introduction to Constraints” – Explore types of constraints and learn how to use them
Next, we’ll learn how to turn workbooks into relational databases with Related Rows.