Basic Project with Gantt and Dependencies

Basic Project with Gantt & Dependencies

This sheet helps you manage your project, and provides an easy-to-grasp visual timeline for your team and clients. Update tasks, manage dependencies, track progress, and store project files — all in one shared sheet.

Template design and key features

Customizable Columns

Done

Quickly check off completed tasks

Task Name

Enter a task name in the Primary Column (used for Smartsheet automated emails)

Start & End Dates

Enter task start & end dates using the date picker, then drag Gantt bars to change

Assigned To

Pick task owners from your Smartsheet contacts

% Complete

Track project status & show progress bars on your Gantt chart

Duration

Calculate automatically from Start & End Dates, or enter a new value

Predecessors

Enter row number for preceding tasks, or drag & drop Gantt bars to set dependencies

Notes

Add status details or other brief notes about each task

Collaborative Features

File Attachments

Store documents & links on any row

Alerts & Reminders

Set alerts for due dates & sheet changes

Comments

Log conversations, emails, & notes

Gantt Chart

See task dates & dependencies

Calendar View

View & edit tasks in a calendar

Row Hierarchy

Organize tasks into collapsible sections

Sharing

Collaborate in real-time with your team

Update Requests

Request updates on task status

Web Forms

Collect new rows & take action

Mobile App

View & update your project on the go

Working with the Gantt chart

3:08

Gantt with Dependencies in Smartsheet

Manage tasks and subtasks with dependencies.

Change dates & set dependencies

Click and drag the edge of a Gantt bar to instantly change dates. Drag one bar onto another to set a dependency.

Set milestones

Enter zero in the Duration column to set a milestone. To work tasks back from a milestone, set Start-to-Finish (SF) dependencies on preceding tasks.

Zoom

Use the Zoom buttons to shift between Weekly, Monthly, and Quarterly views.

Gantt settings

Click the Gantt chart's gear icon to change settings like dependencies and workdays.

Sharing with different access levels

1:27

Sharing Your Sheet

Learn how to share your sheet for easy collaboration.

Share your project with your team

Select the Sharing tab to share with your collaborators. Add collaborator email addresses and select a permission level.

Viewer: can view and export the sheet, but can't make changes
Editor: can edit information in cells, add attachments, set alerts, & create comments
Admin: can add collaborators, edit columns, & change dependency settings

Share multiple sheets in a Workspace

Create a Workspace to share multiple sheets with the same group of people, with consistent sharing permissions on all items in the workspace.

Prevent edits with locked rows & columns

Lock any column or non-blank row to prevent others from changing or deleting key information. Only sheet Owners or Admins can lock, unlock, & edit locked columns & rows.

Collaborating on the project with your team

2:02

Collaborating on Sheets

Learn how to use Smartsheet for real-time collaboration.

Collaborate in real-time

Work simultaneously with everyone shared to the sheet. To help you see changes, Smartsheet will notify you when multiple collaborators are working on the sheet.

Highlight everyone's changes

Select the Highlight Changes button to see all recent changes since the last time you viewed the sheet - or within the day, week, month, or a specific date range.

Get a revision history on any cell

Right click on a cell and select View History to see previous values, who made each change, and when.

Format content automatically

Call attention to key information by setting Conditional Formatting rules to automatically format cells based on the values they contain, such as Done.

Filter down the rows you see

Select Filter Column from the column menu to see a smaller set of tasks in a long sheet.

Getting project updates from your team

2:41

Alerts & Reminders

Track changes to your sheet with email notifications and stay on top of key dates with reminders.

Set Reminders

To set an email reminder on any task in your sheet, select Set Reminder from the row menu. Choose the Alerts tab to trigger Reminders for the whole sheet, or to notify yourself & others of changes to the sheet.

Get automatic updates from your team

Send an update request, a special email designed to allow anyone to update rows on your sheet. Select one or more rows, then use the row menu to send a one-time or recurring request for regular updates.

Managing multiple projects

3:12

Cell Linking in Smartsheet

Learn how to quickly and easily link specific information across sheets.

Link cells across sheets

Use Cell Linking to consolidate information from multiple sheets. You can roll up data from several sheets to build a multi-project dashboard, create cross-project dependencies, or reference cells in other sheets.

Dynamic reviews of multiple sheets

Create a custom Report to see tasks in multiple sheets that meet specific criteria. For example, a Report can show a team member's incomplete tasks due in the coming week on several projects. Updates you make in a Report also update the source sheets.

See who's over-allocated

Use Resource Management to get visibility and alerts on your team's assignments in multiple projects (Team and Enterprise plans only).

Connecting with your apps

2:29

Smartsheet and Google Apps

See how Smartsheet and Google work together

Evernote

Send Evernote notes to Smartsheet to add tasks or archive notes and ideas. Import any Evernote attribute into Smartsheet, then share the details, assign tasks and use reminders to stay on track. Built by Smartsheet Labs.

Google Drive

Attach your Drive files directly to tasks in Smartsheet. Edited documents update automatically in the Smartsheet attachment, so your files are always current.

Google Calendar

Connect Smartsheet and Google Calendar to gain a complete view of all your project tasks and highlight key dates and deadlines. Overlay your Google Calendar on to sheets in Smartsheet, or publish key dates from your project to Google.