What we do
Tools
Industries
Department
How we workLet's talk →
Home/Smartsheet/Smartsheet Project Plan Template Setup Guide
Smartsheet

Smartsheet Project Plan Template: Pick One, Make the Dates Move, Save Your Own

Smartsheet's project plan templates live inside the app, in the Template Gallery and Solution Center, not as files to download. The one most people want is Simple Project Plan. A template gives you the columns and a Gantt chart. What turns it into a plan is switching on dependencies, so one late task pushes everything behind it.

Where the project plan templates are

Fastest: click + in the left navigation bar and pick Simple Project Plan under the popular templates, then Create from template.

+ Simple Project Plan Create from template

To see them all: from the same menu choose More options, then View all templates, preview one and click Use Template. You can name it and choose the folder or workspace it goes into.

+ Create More options View all templates

Already have a plan in Excel or Microsoft Project? Import it instead of starting from a template.

+ Create Import

Which starting point fits your project

Search the gallery for these words. Template names change, so judge each by its preview: look for a Gantt view and Predecessors column.

Your project looks like Start from What to add before kickoff
Under 50 tasks, one team, a fixed end date Simple Project Plan. Dependencies, if any task truly can't start until another ends. Without them it's a list with bars.
Phases with handoffs between teams A project template with Gantt and dependencies already set up. Parent rows for each phase, so phase dates roll up from the tasks under them.
Iterative work in sprints An agile project template from the gallery. Whether you need dates at all, or a board view grouped by status serves the team better.
The same kind of project, over and over Your own template, saved from your best finished plan. Who fills in the client, dates and budget each time. That's the section below.
An existing plan in Excel, Microsoft Project or Google Sheets + Create, then Import. Re-enter predecessors after import if they didn't come across, then check the dates.

Turn the template into a plan that reschedules itself

  1. 1

    Replace the sample rows with your phases and tasks

    Keep the template's columns. Indent tasks under a phase row so the phase becomes a parent. Parent start, end, duration and % complete then roll up from the tasks beneath it and can't be typed over.

  2. 2

    Switch on dependencies

    In the sheet settings (the settings icon at the top right) toggle Dependencies on, or use Project Settings in grid or Gantt view. Map the Duration and Predecessors columns, which become required. You need to be the sheet owner or an admin.

    Watch for: Start date, end date, duration, % complete and predecessors can't hold formulas once dependencies are on.

  3. 3

    Set your working days

    Dates are counted in working days, so set your non-working days and holidays in the same settings before you enter durations. Otherwise every date shifts the first time you change them.

  4. 4

    Link the tasks

    In Predecessors, type the row number of the task that has to come first. Plain numbers mean finish to start. Add SS, FF or SF for the other link types, and a lag such as 4FS +2d for a two-working-day gap.

    Watch for: typing a new date over a date driven by a predecessor removes that row's predecessor. Change the duration or the earlier task instead.

  5. 5

    Assign owners and share the sheet

    Put each owner in the assigned-to contact column so reminders reach them and they can filter to their own work. Share the sheet, or the workspace it sits in, with the people who need to update it.

Saving your plan as a template, and what it never learns

When a plan works, keep it. Open the sheet and choose File, then Save as Template. Under Data & Formatting Options decide whether to keep the rows (usually yes, for a standard task list) and untick attachments and discussions. Under Automated Workflow & Alert Options keep the reminders. Your templates are private, so to give the team access, save it in a shared workspace.

A plan knows what people type into it. The budget column holds the number from kickoff, and % complete holds whatever the task owner last remembered to enter. The hours booked in your timesheet tool and the costs posted in accounting never reach the sheet on their own, so a project can read green in Smartsheet for weeks while the money says otherwise. Most PMs find out at month end, when the variance is already spent.

Smartsheet sells Control Center, a premium add-on, for firms that roll out many projects from one blueprint, which handles the copying. What it can't do is see your other systems. n-frames builds the link through the Smartsheet API that brings actual hours and costs into each plan next to the budget, so the gap shows while it can still be fixed, and the same link can create each new plan already filled in when a job is booked. See Smartsheet automation for what the built-in workflows cover on their own.

Why the Gantt chart stops making sense

A predecessor on a phase row

How you'll know: You can't edit the start dates of tasks inside one phase.

Fix: A predecessor on a parent applies to every child and locks their start dates. Move the link down to the first task in the phase.

Dates edited from a report or the phone

How you'll know: Someone says they moved a date, but nothing changed.

Fix: Dates of dependent tasks can't be changed from a report, an update request or a mobile app. Edit them in the sheet itself.

The template sample data never left

How you'll know: Odd tasks with placeholder owners show up in reports and dashboards.

Fix: Delete every sample row before anyone builds a report or dashboard on the sheet.

Questions people ask

Does Smartsheet have free templates?

The templates in Smartsheet's Template Gallery and Solution Center don't cost anything extra on top of your plan. You open them inside the app and they're created as a new sheet in your account. Creating new sheets needs a paid seat.

Is there a project plan template in Smartsheet?

Yes. Simple Project Plan sits under the popular templates when you click + in the left navigation bar, and the full gallery has more detailed project templates with Gantt views and dependencies already set up.

Can I turn my own sheet into a template?

Yes. Open the sheet, choose File, then Save as Template, and pick what to keep: row data, attachments, discussions, forms, workflows and alerts. Columns and conditional formatting always come along. The template is private until you put it in a shared workspace.

Does Smartsheet have templates for inventory tracking?

Yes. Search the Template Gallery for inventory to find operations templates with stock and reorder columns. If the counts really live in an inventory or accounting system, a sheet only stays right if it's fed from there.

How do I make the dates in a Smartsheet project plan update automatically?

Turn on dependencies, map the Duration and Predecessors columns, then enter each task's predecessor by row number. When an earlier task moves, every task linked behind it moves in working days.

Can a Smartsheet project plan be created automatically for each new job?

Yes, through the Smartsheet API. n-frames builds that: when a deal is won or a job is booked in your CRM or quoting tool, a new plan is created from your template with the job details already filled in.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.