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.
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.
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 templateTo 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 templatesAlready have a plan in Excel or Microsoft Project? Import it instead of starting from a template.
+ Create › ImportSearch the gallery for these words. Template names change, so judge each by its preview: look for a Gantt view and Predecessors column.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.