Can You Make a Gantt Chart in Google Sheets? 7 Easy Steps

Can you make a Gantt chart in Google Sheets? Yes. You can build one with task names, start dates, durations, and a color-coded timeline without specialized project software.

The tricky part is getting the dates, formulas, formatting, and task dependencies to work together. A small mistake can shift every bar, hide an overdue task, or make the schedule difficult to update.

But here's the truth: Google Sheets gives you enough flexibility for a clear, lightweight project timeline. You only need a simple layout, a few formulas, and conditional formatting.

This guide walks you through seven practical steps. You’ll also learn when Sheets works well, where it becomes difficult, and how a dedicated project platform can support larger teams.

How to Make a Gantt Chart in Google Sheets

A Gantt chart in Google Sheets uses task rows and date columns. Conditional formatting colors the cells that fall between each task’s start date and finish date.

Follow these seven steps to create a working schedule.

1. Create the Basic Project Table

Open a blank Google Sheet and create these columns in the first row:

• Task
• Start Date
• End Date
• Duration
• Owner
• Status

For example, your first few rows might look like this:

Keep one task per row. This makes filtering, sorting, and updating the schedule much easier later.

2. Enter Start and End Dates

Enter real calendar dates in the Start Date and End Date columns. Google Sheets can recognize entries such as 4/1/2025 or April 1, 2025.

Use a consistent date format across the project. Select the date columns, choose Format, select Number, and then choose Date.

You can also use formulas when a task begins after another task finishes. For example, if the previous task ends in cell C2, enter this in the next start-date cell:

=C2+1

This starts the next task one day after the earlier task ends.

3. Calculate Task Duration

In the Duration column, subtract the start date from the end date and add one day:

=C2-B2+1

Here, B2 contains the start date and C2 contains the end date. The added one counts both the first and last day.

For example, a task running from April 1 through April 3 lasts three calendar days. Without the added one, the formula would return two.

Copy the formula down the column by dragging the small blue square in the lower-right corner of the selected cell.

4. Add the Timeline Dates

Start the visual timeline in a blank column to the right of your project details. If your last project column is F, enter the first timeline date in G1.

Enter the next date in H1 with this formula:

=G1+1

Drag the formula across as far as your project needs. A three-week schedule needs roughly 21 date columns, while a six-month schedule may need too many columns for comfortable editing.

Format the timeline headers as short dates, such as Apr 1. Narrow columns make the chart more compact, but leave enough width for the dates to remain readable.

5. Apply Conditional Formatting

Now turn the timeline into colored task bars.

1. Select the timeline range, such as G2:AA20.
2. Open Format and choose Conditional formatting.
3. Under the formatting rules, select Custom formula is.
4. Enter =AND(G$1>=$B2,G$1<=$C2).
5. Choose a fill color.
6. Select Done.

The formula checks whether each timeline date falls between the task’s start and end dates. If it does, Google Sheets colors that cell.

Make sure the dollar signs are placed correctly. The row number in G$1 stays fixed for the header row, while the task row in $B2 changes as the rule moves down.

6. Improve the Layout and Readability

A working chart can still be difficult to read. Make a few visual adjustments before sharing it.

• Bold the header row.
• Freeze the task columns with View and Freeze.
• Center the timeline dates.
• Use alternating colors for task categories.
• Wrap long task names.
• Apply borders around the timeline.
• Use a separate color for milestones.

You can highlight today’s date with another conditional-formatting rule:

=G$1=TODAY()

Choose a vertical accent color for this rule. The chart will then show where the project stands each day.

7. Add Status, Progress, and Dependencies

A basic Gantt chart shows timing. You can make it more useful by adding project controls.

Add a dropdown to the Status column with options such as Not started, In progress, Blocked, and Complete. Use Insert, Dropdown to create it.

For progress tracking, add a Progress column and enter percentages such as 25%, 50%, or 100%. You can highlight completed rows with a rule such as:

=$F2="Complete"

Dependencies require more care. Add a Predecessor column and record the task that must finish first. For simple projects, a formula can calculate the next start date. Complex dependencies may need manual review or a dedicated project management platform.

How the Schedule Formula Works

The visual effect comes from comparing each timeline date with the dates assigned to a task.

Suppose the timeline date is in G1, the task starts in B2, and the task ends in C2. This formula creates the bar:

=AND(G$1>=$B2,G$1<=$C2)

The first condition asks whether the timeline date is on or after the start date. The second asks whether it is on or before the end date.

When both conditions are true, conditional formatting applies the selected color. When either condition is false, the cell stays uncolored.

Here's why this matters: you can change one start or end date, and the bar updates automatically. You do not need to recolor individual cells.

Calendar Days Versus Workdays

The standard formula counts calendar days, including weekends. That works for event planning, content campaigns, and schedules that run continuously.

For weekday-only planning, use the NETWORKDAYS function:

=NETWORKDAYS(B2,C2)

However, the visual timeline still contains weekend columns. You can hide weekends manually or use a more advanced layout with workday-only headers.

Milestones and Zero-Day Events

A milestone usually has one date rather than a multi-day duration. Add a Milestone column or give the task identical start and end dates.

Then create a separate formatting rule, such as:

=AND(G$1=$B2,$D2="Milestone")

Use a diamond-style symbol such as ◆ in the task row if you want a stronger visual marker.

When Google Sheets Works Well

Google Sheets is a practical choice for small projects, personal planning, and teams that need a quick shared timeline.

For example, a three-person marketing team can plan a product launch with 15 tasks, six owners, and a four-week schedule. Everyone can view the same chart and update status during a weekly meeting.

The biggest advantage is speed. You can build a basic chart in minutes without learning a new project system.

It also works well when your team needs flexible calculations. You can add budgets, notes, approval dates, or custom scoring beside the timeline.

Good Fits for a Sheets Gantt Chart

• Short campaigns with clear start and end dates.
• Simple content calendars.
• Small construction or renovation plans.
• Student assignments and research schedules.
• Personal event planning.
• Early project discovery before selecting a formal platform.

The chart becomes less comfortable when the schedule contains hundreds of tasks, multiple dependency types, frequent reassignment, or detailed workload planning.

Common Limitations to Expect

Google Sheets shows timing clearly, but it does not automatically behave like a full project management system.

For instance, changing one task may require you to inspect several related tasks manually. If a review slips by three days, downstream dates will not always move in the way you expect.

You also need to maintain formulas, formatting rules, dropdowns, and permissions. A teammate who overwrites a formula can quietly damage the chart.

Here's the practical dividing line: Sheets is excellent for visibility and lightweight coordination. It becomes harder to manage when you need structured execution across many teams.

Signs You Have Outgrown the Manual Approach

• People regularly edit the same schedule at the same time.
• Tasks need several predecessor relationships.
• Managers need workload or capacity views.
• You need a reliable activity history.
• Approvals happen across multiple departments.
• Reports must update without manual cleanup.
• Different teams use separate planning methods.

At that stage, moving the plan into a project management platform can reduce maintenance and make accountability clearer.

Practical Tips for Maintaining the Timeline

A Gantt chart stays useful only when people trust it. Set one owner for schedule maintenance, even if several people update task status.

Use a weekly review to check four items: overdue work, blocked tasks, upcoming milestones, and dates that changed without a reason.

Keep task names action-oriented. “Landing page” is vague, while “Approve landing page copy” tells everyone what completion means.

Limit each task to a manageable piece of work. A single row named “Launch campaign” may hide planning, design, approvals, testing, and release activities.

Use a Simple Status System

Too many status labels create confusion. A compact set usually works better:

• Not started: Work has not begun.
• In progress: Someone is actively working on it.
• Blocked: Progress depends on an unresolved issue.
• Complete: The agreed result is finished.

Use a separate risk or priority column when necessary. Avoid turning the Status field into a long description of every problem.

Google Sheets Gantt Chart Solution: ONES.com

Value Proposition

ONES.com brings project management and knowledge management into one platform powered by ONES Assistant. ONES Project is a Jira alternative for teams that need structured planning beyond a manually maintained timeline.

It is available through Cloud, On-Premise, Private Cloud, and Air-gapped deployments. The free plan supports up to 30 seats, and the self-hosted versions provide feature parity with the cloud version.

Core Capabilities

Scattered schedules → Structured project planning → Clear ownership

When tasks sit across separate planning methods, ONES Project organizes work into projects, tasks, owners, statuses, and deadlines. Everyone can see responsibility in one place.

Manual timeline updates → Gantt and schedule views → Faster progress checks

Instead of adjusting colored cells by hand, you can manage planned work through project views designed for scheduling. Date changes remain connected to the task record.

Rigid task structures → Custom workflows and fields → Better process fit

Different teams can track the information they actually need. Custom workflows and fields support engineering, marketing, operations, and approval-heavy work.

Plugin-heavy processes → Native project capabilities → Less maintenance

ONES Project includes sprint management, automation, built-in reporting, and Jira-compatible workflows. Native capabilities can reduce the need to connect multiple add-ons.

Limited reporting → Built-in reports → More consistent decisions

Managers can review project progress through built-in reporting instead of manually calculating status across several planning views.

Restricted networks → On-premise or air-gapped deployment → Greater deployment control

Teams with strict infrastructure requirements can choose self-hosted deployment options. Air-gapped environments support work in networks without external connectivity.

Disconnected knowledge → ONES Wiki → Easier access to project context

Project work often depends on requirements, decisions, and procedures. ONES Wiki provides a knowledge base alongside project management, and it is sold separately from ONES Project.

Growing team complexity → Unified ONES.com platform → A broader work system

When planning and knowledge need to connect, ONES.com offers both products under one platform while allowing you to purchase them separately.

Application Scenarios

A software team can use ONES Project for sprint planning, defect tracking, custom workflows, and reports while retaining Jira-compatible processes.

An organization with restricted network requirements can deploy the platform on-premise or in an air-gapped environment, preserving control over its operating setup.

A marketing department can manage launch tasks in ONES Project and maintain campaign guidelines or approval procedures in ONES Wiki.

Common Challenges and Practical Solutions

Challenge: The Timeline Becomes Too Wide

A daily timeline can become difficult to navigate across several months. Group dates by week or month when the project does not require daily precision.

For example, use weekly columns for a six-month rollout and daily columns for a two-week launch sprint.

Challenge: Formulas Stop Working

Someone may paste over a formula or change a date into plain text. Protect formula columns and use date validation to catch incorrect entries early.

Keep an untouched template so you can restore the structure if the working chart becomes damaged.

Challenge: Dependencies Are Hard to Track

Color bars show timing, but they do not always explain why a task moved. Add a Predecessor column and review linked tasks during every schedule update.

For complex relationships, use project software that can manage dependencies directly.

Challenge: Status Updates Are Inconsistent

One person may mark a task complete while another considers it awaiting approval. Define completion criteria and use a small, shared status list.

Challenge: The Chart Contains Too Much Detail

A Gantt chart should help people understand timing quickly. Move long notes, meeting details, and background explanations into a separate planning area or knowledge base.

FAQs

Can you make a Gantt chart in Google Sheets without a template?

Yes. You can create one manually with task details, start and end dates, timeline headers, and conditional formatting. The key formula compares each timeline date with the task’s start and end dates. Templates can save time, but they are not required.

Is Google Sheets good for project scheduling?

It works well for small projects with straightforward dates and limited dependencies. You can share the schedule, add dropdowns, and adjust formulas quickly. Larger projects may require stronger dependency management, workload planning, change tracking, and reporting.

How do I show weekends in a Sheets Gantt chart?

The basic approach includes every calendar day, so weekends appear automatically. You can shade weekend columns with conditional formatting or hide them manually. If your team works only on weekdays, use NETWORKDAYS for duration calculations.

How do I show project progress?

Add a Progress column with percentage values and a Status column with controlled options. You can use conditional formatting to shade completed rows or add a progress bar with a formula. Keep progress and status separate because a task can be in progress at 50% or blocked at 80%.

Can multiple people edit the same Gantt chart?

Yes. Google Sheets supports shared editing and permission controls. However, simultaneous changes can create accidental overwrites, especially in formula columns. Protect calculated areas, define editing responsibilities, and review important date changes regularly.

When should I use a dedicated project management platform?

Consider one when your team manages many dependencies, repeated workflows, cross-team approvals, workload planning, or detailed reporting. A dedicated platform can reduce manual upkeep and connect tasks with accountability, automation, and project history.

Conclusion

So, can you make a Gantt chart in Google Sheets? Yes. Build the task table, add start and end dates, calculate duration, create timeline headers, and apply conditional formatting.

The approach works especially well for small projects and simple schedules. Keep the chart readable, protect formulas, and review dates regularly so the timeline remains trustworthy.

But here's the truth: a manual chart can become fragile as dependencies, teams, and reporting needs grow. When that happens, a structured platform such as ONES.com can provide connected project planning, workflows, automation, and deployment options.

Start with Google Sheets when speed and simplicity matter. Move to a dedicated system when maintaining the schedule takes more effort than managing the work.