Easy Tech TutsHow to Calculate Project Level Percent Complete In Smartsheet Easily 2026
By Impran M NLast checked against official docs
Manually tracking overall project completion gets unreliable fast once dozens of subtasks are each moving at their own pace. Smartsheet has two different ways to roll individual task percentages up into one project-level number, and which one applies to your sheet depends on a setting you may not have looked at yet: whether Dependencies are turned on. This guide covers both paths, plus the structure and formatting that makes either one work.
Before you start
- A sheet with a Task Name column and individual tasks already listed as rows
01Set up your % Complete column
Open your schedule sheet and confirm the % Complete column sits alongside your core tracking fields, Task Name, Start Date, End Date, and Priority. Each task row carries its own percentage, say 100% for a finished Design Phase or 50% for a Development Phase still underway, and this per-row number is what every rollup later reads from. If the column isn't formatted as a percent type, fix that first; a plain number column won't display or calculate the way you expect.
02Organize tasks into parent-child rows
Group related tasks under a parent row, for instance nesting Design Phase, Development Phase, Testing Phase, and Deployment Phase underneath a Website Project parent. This hierarchy is what any rollup, automatic or formula-based, reads to know which child rows belong to which parent.
03Check whether Dependencies are enabled before you write a formula
This is the fork in the road. If Project Settings has Dependencies turned on for this sheet, Smartsheet calculates the parent row's % Complete for you: a weighted average based on each child row's duration and % Complete, so a two-week task moves the parent number more than a five-minute one.
With Dependencies on, the parent's % Complete cell becomes read-only. You can't type a formula into it, and rows that are milestones (duration of 0) are excluded from that calculation entirely.
If Dependencies are off, which is normal for a simple task list without scheduled dates, nothing rolls up on its own. Write your own formula in the parent's % Complete cell: =AVG(CHILDREN()) for a plain average across child rows, or =AVGW(CHILDREN([% Complete]@row), CHILDREN([Weight]@row)) against a helper column of durations or effort points if some tasks should count more than others. A straight average treats a five-minute task the same as a two-week one, so weighting usually gives a more honest number.
04Flag completed work with a condition
Open Conditional Formatting, select the % Complete column, and set a condition so rows hitting 100% are visually flagged, separate from the ones still at 25%, 50%, or 75%. Seeing which tasks are genuinely finished versus still in progress at a glance makes it faster to sanity-check a rollup number before presenting it. A project reporting 80% complete should have a matching cluster of tasks actually sitting at 100%.
05Display the master number in Sheet Summary
Use the Sheet Summary panel to pull out a single project-level completion percentage as its own summary field, separate from the row-by-row detail in the grid. This is the figure worth pinning to a dashboard or reporting up the chain, since it answers "where are we" without anyone opening the full sheet.
When it doesn't work
The parent row's % Complete cell won't accept a formula, it's greyed out
Why: Dependencies are enabled on the sheet, which makes Smartsheet calculate that cell automatically and locks it against manual entry.
Fix: If you need a custom formula instead, either turn off Dependencies in Project Settings, or build your CHILDREN/AVGW formula in a separate helper column rather than the dependency-controlled % Complete cell.
A milestone task doesn't seem to affect the parent's rollup at all
Why: With Dependencies enabled, Smartsheet's automatic rollup skips child rows that are milestones, meaning rows with a duration of zero, entirely.
Fix: If milestones need to count toward the number, switch that parent cell to a manual CHILDREN()-based formula instead of relying on the automatic dependency rollup.
A manual AVG(CHILDREN()) formula gives a number that looks off
Why: Blank % Complete cells among the children aren't necessarily treated as 0 the way you'd expect, which can skew the average.
Fix: Fill blank child cells with 0% before relying on the rollup, or wrap the formula with COUNT/IFERROR checks and test it against a row set that includes at least one blank.
Frequently asked questions
Does Smartsheet calculate % Complete automatically?
Only if Dependencies are turned on for the sheet in Project Settings. Then the parent row's % Complete is a weighted average of its children's duration and completion, calculated for you and not editable by hand.
How do I weight some tasks more heavily than others without Dependencies?
Write a formula like =AVGW(CHILDREN([% Complete]@row), CHILDREN([Weight]@row)) referencing a helper column of durations or effort points, instead of a plain average.
Why doesn't a milestone task affect the project percentage?
Smartsheet's automatic dependency-based rollup excludes rows with zero duration, which is what a milestone typically is. A manual CHILDREN() formula can include them if that's what you want.
Where can I see the overall project completion number?
The Sheet Summary panel can hold a single master field showing your project-level completion percentage, separate from the row-by-row detail in the grid.
Can I write my own rollup formula on a sheet that already has Dependencies enabled?
Not in the % Complete cell itself, since Dependencies makes that cell read-only. Use a separate helper column for a custom formula, or turn Dependencies off if you don't need its scheduling features.
Sources and last check
Screens and the column/hierarchy setup come from a walkthrough of a sample schedule sheet. The rollup mechanics were re-checked against Smartsheet's official Learning Center article in September 2026, which corrected this guide's earlier framing: CHILDREN/AVGW formulas and the Dependencies Engine aren't two options to pick between on the same cell, dependencies-enabled rollup is automatic and read-only, excludes milestone rows, and only sheets without Dependencies turned on need a manual formula.
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
