How to Set Up a Smartsheet Gantt Chart (The Right Way)

To set up a Gantt chart in Smartsheet, add Start Date and End Date columns to your sheet, then select Gantt view in the toolbar. Open Project Settings, enable dependencies so Smartsheet assigns Predecessor and Duration columns, and let predecessors drive your dates instead of typing them by hand. That last part is where most setups go wrong.

I build project sheets for client PMOs every week, and the pattern is consistent. The Gantt itself takes five minutes. The schedules that survive contact with a real project are the ones where dependencies, working days, and a baseline were configured before anyone typed a single date. Here is the full sequence, in the order I actually do it.

What your sheet needs before Gantt view will work

Gantt view has two hard prerequisites, and both generate support tickets. Your sheet needs at least two date-type columns, and neither can be populated by a column formula. If the Gantt option appears grayed out, one of those conditions is the culprit — usually a well-intentioned column formula someone added to calculate end dates. Smartsheet’s own Gantt view documentation confirms both requirements.

You also need Owner or Admin permissions on the sheet to change Project Settings. Editors can work in the Gantt once it exists; they cannot configure it. If you are brand new to the platform, start with our Smartsheet beginner setup guide and come back once you have a sheet to work with.

Step 1: Switch to Gantt view

1. In Grid view, add two date columns if you do not have them: right-click a column header, select Insert Column Right, and set the column type to Date. Name them Start Date and End Date.
2. Select Gantt view from the view switcher in the toolbar. The chart renders to the right of your columns.
3. Drag the vertical divider between the grid and the chart to control how much of each is visible.
4. Use the Zoom In and Zoom Out controls to move between day, week, month, and quarter timescales.

At this point you have bars, not a schedule. Rows with identical start and end dates draw a single-day bar, and rows with only one of the two dates draw a milestone diamond. Nothing recalculates yet — that is what dependencies are for.

Step 2: Enable dependencies

1. Right-click any column header and select Edit Project Settings, or select the settings gear in the top-right corner of the Gantt view.
2. Under Dependency Settings, check Dependencies enabled.
3. Confirm the Predecessor column and Duration column assignments. If those columns do not exist, Smartsheet creates them automatically.
4. Optionally assign a % Complete column to overlay progress shading on the task bars.
5. Select OK.

Three things change immediately, and I warn every client about them. First, enter any two of start date, end date, or duration and Smartsheet calculates the third. Second, parent rows become read-only rollups of their children — you can no longer type dates on a phase header. Third, formulas are now blocked in the Start Date, End Date, Duration, % Complete, and Predecessors columns. If your sheet relied on date formulas, decide now whether you want automation from dependencies or from formulas. You cannot have both in those columns.

Step 3: Set working days, day length, and holidays

Do this before entering durations, not after. A 10-day task quietly becomes a different calendar span the moment you change the working week, and every dependent task shifts with it.

1. Open Project Settings again and go to the Working Days options under Dependency Settings.
2. Check the days of the week your team actually works.
3. Set the Length of day (hours) value. Smartsheet defaults to 8 hours, which matters as soon as you use partial-day durations like 3.5d or 7h.
4. Add company holidays and shutdown periods as Non-working days. Task bars skip those dates automatically.

The holiday list is the step teams skip, and it is why one client’s December plan showed a deliverable landing on Christmas Day. Smartsheet knows nothing about your public holidays until you enter them — the working days documentation covers the full set of options.

Step 4: Build the schedule with predecessors

1. Enter a Duration for each task using working-day formats such as 4d, 2w, or 7h. Prefix with e for elapsed time that ignores non-working days, such as e3d.
2. In the Predecessors column, type the row number of the task that must happen first. Separate multiple predecessors with commas.
3. Enter a start date only on the first task in each chain. Every dependent date downstream calculates itself.
4. To change a relationship type or add lag, open Edit Predecessors from the cell and set the Type and Lag fields. A lag of 2d inserts a two-day gap; -2d creates overlap (lead time).

Now the mistake I fix more than any other: manually typing an end date on a task that has a predecessor. Smartsheet treats the manual date as an override and silently deletes the predecessor value from that row. The plan keeps looking fine until an upstream task slips and that row does not move with it. If a date looks wrong, fix the duration, the predecessor, or the lag — never the date cell itself. The official dependencies article documents this override behavior.

A related limitation surprises distributed teams: predecessor-driven start and end dates cannot be edited from a report, a row update request, or the mobile apps. Collaborators should adjust a task’s duration or flag the row, and let the sheet owner manage the chain.

Step 5: Milestones and the critical path

With dependencies on, a milestone is simply a task with zero duration — Smartsheet draws it as a diamond. I add zero-duration rows for every contract gate and executive review, because diamonds are what sponsors actually look at.

1. Add a row for the milestone and set its Duration to 0.
2. Give it a predecessor so it moves with the work that drives it.
3. To highlight the critical path, select the Critical Path icon in the upper-right area of the Gantt view. Tasks with no float are highlighted.
4. To isolate those tasks for a status meeting, create a Filter on critical path status.

Step 6: Set a baseline before work starts

Baselines snapshot your planned dates so you can measure slippage later. They are included in the Pro, Business, and Enterprise plans, and only sheet Owners and Admins can set them.

1. In Gantt view, select the Baselines button in the toolbar.
2. Select Set. Smartsheet adds read-only Baseline Start, Baseline Finish, and Variance columns.
3. Toggle Show baseline in Gantt to draw baseline bars beneath the live bars. This display preference applies only to your own view.
4. Use Reset only when scope formally changes — it overwrites the snapshot and zeroes every variance.

Two constraints to plan around, straight from the baselines documentation: a sheet holds exactly one baseline, and baseline bars do not appear in reports, dashboard widgets, or printed Gantt output. The Variance column does carry into reports, which is what I use for weekly slippage reporting anyway.

Sharing and publishing the chart

1. Select File, then Publish.
2. Choose Read Only – Full if viewers need the actual Gantt. The lighter Read Only – HTML option renders grid data only, with no way to switch to Gantt view.
3. In the publish settings, set the default view to Gantt so stakeholders land on the chart rather than the grid.
4. Copy the link or the embed code.

Remember that a published link works for anyone who has it. For anything commercially sensitive I share the sheet with Viewer permissions instead, or surface it through a dashboard.

Gantt view vs timeline view

Smartsheet ships two date visualizations, and clients regularly conflate them. Gantt view is the scheduling engine: dependencies, critical path, baselines. Timeline view is a lighter, presentation-friendly way to lay work out against dates, and it only needs a single date column to render.

What you need to pay for

Everything in steps 1 through 6 works on the entry-level Pro plan, currently 9 dollars per member per month billed yearly (12 dollars billed monthly) with a 10-member cap; Smartsheet notes Pro is only sold to new customers. Business, at 19 dollars per member per month billed yearly with a 3-member minimum, adds timeline view, workload tracking, unlimited automations, and the Resource Management project settings. Enterprise pricing is custom. Data Shuttle, Control Center, and Dynamic View now sit in the separate Advanced Work Management tier — our Data Shuttle setup guide covers what that tier is actually for, and the full plan-by-plan detail is in our Smartsheet pricing breakdown.

When Smartsheet’s Gantt is the wrong tool

I say this as a Smartsheet consultancy: the Gantt is not the answer to everything. Smartsheet does not do effort-driven scheduling or automatic resource leveling — it will not re-plan tasks around a person’s availability the way Microsoft Project can. Workload tracking on the Business plan shows you an overallocation; it does not resolve one. If your schedule quality depends on shared resources across a portfolio, read our Smartsheet vs Microsoft Project comparison before committing, and pair any serious Gantt deployment with the capacity planning covered in our Smartsheet Resource Management guide.

Iterative teams are the other mismatch. If work is reprioritized weekly and nobody cares about end-date variance, board view will serve you better than a Gantt that is perpetually out of date.

Frequently asked questions

Why is the Gantt view option grayed out?

Your sheet is missing one of the two requirements: at least two date-type columns, populated without column formulas. If the sheet has several date columns, also check that Project Settings points at the correct start and end columns. Fix those and the toolbar option activates immediately — no rebuild needed.

Can I use formulas in the Start Date or End Date columns?

Not with dependencies enabled. Smartsheet blocks formulas in the Start Date, End Date, Duration, % Complete, and Predecessors columns once dependencies are on. If you need formula-driven dates, keep dependencies off and accept a static Gantt, or move the calculations into helper columns that do not feed the chart.

How do I create a milestone in a Smartsheet Gantt chart?

With dependencies enabled, set the task’s Duration to 0 and it renders as a diamond. Without dependencies, a row containing only a start date or only an end date also draws a diamond. Give milestones predecessors so they shift automatically whenever the upstream work moves.

Which Smartsheet plan includes baselines and critical path?

Both are available from the Pro plan up, so you do not need Business for core Gantt scheduling. Business adds timeline view, workload tracking, and Resource Management settings. On any plan, only the sheet Owner and Admins can set baselines or change Project Settings.

Why can’t my team edit task dates from a report or their phone?

Predecessor-driven start and end dates are locked in reports, row update requests, and the mobile apps by design. Have collaborators change a task’s duration instead — the end date recalculates automatically — or manage the predecessor chain from the sheet itself in a desktop browser.

Sponsored