Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementProject PlanningProject Plan with Gantt Timeline

SpreadsheetProject PlanningFree

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

Shown with sample data

Colour

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

Overall progress
33%
Weighted by task length
Days to deadline
54
Late tasks
2
At risk
2
Progress by phase
  • Initiate100%
  • Plan95%
  • Design52.2%
  • Build10.7%
Days of work by status
  • At risk4831%
  • Not started3925%
  • On schedule2617%
  • Late2214%
  • Done2113%

How to use it

  1. 1On the Settings sheet, set the Monday the timeline starts.
  2. 2List tasks under each phase with owner, start and end dates; keep tasks between one and ten days.
  3. 3Add milestones as tasks with the same start and end date; they show as a diamond.
  4. 4Update % complete each week; the solid part of each bar is the work done, red is overdue.
  5. 5Review Late and At risk tasks and the Phases sheet in your status meeting.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A project plan with a live Gantt chart, like the best Excel and Smartsheet project templates. Enter each task with its phase, owner, start and end dates and % complete; the timeline draws a bar across the weeks it runs, shades the finished part, turns overdue work red and marks milestones with a diamond. Schedule status flags late and at-risk tasks against today, and a phase summary rolls everything up for status reports.

Who it’s for

  • Projects with a fixed deadline
  • Agency and client delivery plans
  • Launches, events and implementations
  • Weekly status meetings

What’s included

  • Plan sheet: Tasks by phase with dates, progress and the Gantt timeline.
  • Phases sheet: Each phase rolled up from its tasks.
  • Settings sheet: Where the timeline starts.

How to use it

  1. 1On the Settings sheet, set the Monday the timeline starts.
  2. 2List tasks under each phase with owner, start and end dates; keep tasks between one and ten days.
  3. 3Add milestones as tasks with the same start and end date; they show as a diamond.
  4. 4Update % complete each week; the solid part of each bar is the work done, red is overdue.
  5. 5Review Late and At risk tasks and the Phases sheet in your status meeting.

Tips

  • Write the task each one depends on in Depends on, and start it after that task ends.
  • Move the timeline start forward every month to keep the next 16 weeks in view.
  • A task more than 15 points behind where its dates say it should be is flagged At risk.

Questions

How is schedule status decided?

Done at 100%; Late when the end date has passed; At risk when the share of time used is more than 15 points ahead of % complete; Not started before the start date; otherwise On schedule.

How do I see more weeks?

Change the timeline start on the Settings sheet. The bars move to the 16 weeks from that date.

What do the bar colours mean?

Solid is work done, light is work still planned, red is past weeks that are not finished, and a diamond is a milestone.

Related searchesgantt chartproject planproject scheduletimelinework breakdown structureproject timeline template

Details

Format
Spreadsheet
Category
Project Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProject PlanningFree

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Project Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More project planning templates

View all
Project Tracker
Task
OctNov
Customer survey launched
Pricing page copy
Partner contract signed
Onboarding email sequence
Analytics dashboard
Sales training deck
SpreadsheetProject Planning

Project Tracker

Deliverables with owner, priority, dates, progress, health and a workload view by person.

10 min setupPreview
Work Breakdown Structure (WBS)2 sheets

Work packages

9

Total effort (hours)

386

Total cost

$42,040

ABCD
1WBS codeStageDeliverableWork package
21.11 DiscoveryRequirementsStakeholder interviews
31.21 DiscoveryRequirementsRequirements document and sign-off
42.12 DesignExperience designUser flows and wireframes
52.22 DesignVisual designDesign system and page designs
WBS
SpreadsheetProject Planning

Work Breakdown Structure (WBS)

Break a project into phases, deliverables and work packages with effort, cost and owner rolled up by phase.

10 min setupPreview
Project Portfolio Dashboard3 sheets

Portfolio budget

$3,305,000

Spent to date

$2,027,500

Portfolio CPI

1

Budget by programme
$1.2M
$910k
$820k
$415k
DigitalOperationsCustomerCompliance
SpreadsheetProject Planning

Project Portfolio Dashboard

Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.

25 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ