Project Management and Gantt Charts

Project Management and Gantt Charts

Modify Project Settings

With sheet project settings, you can customize aspects of the sheet such as working and non-working time, Gantt display settings, and resource managem...

Enable Dependencies and Use Predecessors

You can use the Dependencies functionality in Smartsheet for automatic calculation and adjustment of dates as values for Duration (how long something ...

Define Working Days, Non-working Days, and Holidays on a Project Sheet

The sheet owner and collaborators with Admin access to a dependency-enabled project sheet can configure non-working days and holidays for the project,...

Create a Milestone to Mark a Significant Event in Your Project

A milestone is an action or event marking a significant change or stage in your project....

Create and Work With a Gantt Chart

Display tasks in your sheets and reports as bars in a timeline with a Gantt chart....

Adjust the Gantt Chart Timeline

The Gantt chart has 4 timeline zoom levels: quarter, month, week and day....

Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors

In a project sheet, you can enable automated dependency functionality in the following columns: Start and End Date Duration % Complete Predeces...

Parent Rollup Functionality

When Dependencies are enabled on a project sheet, Parent Rows automatically roll-up information in several of the Project Sheet Columns....

Track the Critical Path in a Project

Track the key tasks in your project by setting it up to display the critical path....

View Your Assigned Tasks

To quickly find all tasks that are assigned to you or to someone else, do either of the following: To view tasks from one sheet only, use a filte...

Resource Management and Allocation

With Resource Management, you can track and review how people are allocated across all of the projects they are working on to adjust and make better d...

Highlight the Driving Path of a Subtask

With driving path, you can see which other tasks (based on predecessor relationships) affect a task’s start date....

Assign People to a Task

In Smartsheet, you can use the Contact List column type to assign tasks to team members....

Identify Tasks That Affect the End Date of a Summary Task

Enable the summary path on a collection of tasks to outline the subtasks that affect the completion date of their summary (parent) task....

Gain Insight into Resource Allocation with Project Resource View

A resource view provides a visual way to track and review how people in your Smartsheet plan (resources) are allocated across the projects they're wor...

Batch Copy to Standardize Sheet Summaries Across Sheets

Maintain consistency with your metadata and portfolio data by copying the sheet summary structure, formulas, and other content to up to 20 existing sh...

Sheet Summary

Define Your Work With Sheet Summary

Sheet summary provides a standard location to define, organize, and report on custom project, business, and summary level information....

Provide Context to Symbols With a Sheet Summary Legend

Build a legend in the sheet summary to describe the meaning of each icon or symbol on your sheet....

Create a Portfolio View with a Sheet Summary Report

Aggregate your summary data across multiple sheets using sheet summary reports to create a portfolio-level view....

Take Full Advantage of Sheet Summary: Tips and Best Practices

Take advantage of sheet summary to display overall project metrics, tag sheets with custom metadata for better search, and more....

Calculate Key Project Metrics With Sheet Summary Formulas

Automatically calculate budget summaries, aggregate project status and project health, and more by placing formulas in sheet summary fields....