How to Make a Gantt Chart in Google Sheets: 7 Steps in 2026

A project can feel simple until deadlines, dependencies, and changing priorities start colliding. Then a basic task list becomes difficult to read, and missed handoffs can push the whole schedule behind.

That is why many people search for a quick way to build a Gantt chart in Google Sheets. The challenge is getting dates, task duration, progress, and dependencies to display clearly without spending hours on formatting.

But here's the truth: you can create a useful Gantt chart in Google Sheets with formulas, conditional formatting, and a structured timeline. I’ll walk you through seven practical steps, show you how to keep the chart accurate, and explain when a dedicated project management platform makes more sense.

How to Make a Gantt Chart in Google Sheets in 7 Steps

A Gantt chart in Google Sheets uses task information in rows and calendar dates across columns. Conditional formatting then colors the cells that fall between each task’s start date and end date.

Here’s why: the chart does not require a special template. You only need a task list, date columns, and one formula that connects the two.

1. Create a task planning area.

   Open a new Google Sheets workbook and create columns for the information you need. A practical starting layout includes:

   • Task ID
   • Task name
   • Owner
   • Start date
   • End date
   • Status
   • Progress

   For example, row 2 might contain “Design homepage,” owned by Mia, with a start date of March 2 and an end date of March 6.

2. Enter tasks and project dates.

   List one task per row. Keep each task focused on a meaningful piece of work, such as “Approve wireframes” or “Prepare launch email.” Avoid combining several unrelated activities in one row.

   Enter real start and end dates rather than relying on task names to explain timing. Format both columns as dates by selecting the cells and choosing Format > Number > Date.

   If a task lasts one day, use the same date in both date fields. This prevents short activities from disappearing from the timeline.

3. Build the calendar timeline.

   Choose a row above or beside your task list for the timeline. Enter the project’s first date in the first timeline cell, such as H1.

   In the next cell, enter:

   =H1+1

   Drag the formula across the row until you reach the project’s final date. Format these cells as dates, then adjust the display if you want shorter labels such as “Mar 2” or “Mon.”

   For longer projects, create weekly columns instead of daily columns. In that case, each heading can represent the Monday of a week, and the formatting formula should compare tasks against weekly ranges.

4. Reserve space for the visual bars.

   Place the timeline immediately after your task details. For example, if your task information occupies columns A through G, begin the calendar in column H.

   Freeze the task columns so names remain visible while you scroll across the schedule. Select the appropriate column, then choose View > Freeze.

   Make the timeline columns narrow enough to show the overall schedule. A chart covering 90 days becomes difficult to scan when every date column is too wide.

5. Add conditional formatting.

   Select the calendar area that covers your tasks and dates. For example, select H2:AZ20 if your timeline begins in column H and your task list reaches row 20.

   Open Format > Conditional formatting. Under the formatting rules, choose Custom formula is.

   Assuming the start date is in column D, the end date is in column E, and the first calendar date is in H1, use:

   =AND(H$1>=$D2,H$1<=$E2)

   Choose a fill color and select Done. Google Sheets will color every calendar cell whose date falls within the task’s start and end range.

   The dollar signs matter. H$1 keeps the formula tied to the timeline header row, while $D2 and $E2 keep the date columns fixed as the rule moves across the chart.

6. Show progress or status.

   A basic Gantt chart shows planned timing. Adding progress helps you compare the plan with actual work.

   You can add a percentage column with values such as 0%, 25%, 50%, 75%, and 100%. Another option is a status column containing “Not started,” “In progress,” “Blocked,” or “Complete.”

   Use separate conditional formatting rules for statuses. For example, blue can represent active work, green can represent completed work, and red can highlight blocked tasks.

   For a simple progress overlay, create a second rule using the progress value. If progress is in column G, you might use:

   =AND(H$1>=$D2,H$1<=$D2+($E2-$D2+1)*$G2-1)

   Apply a darker color to distinguish completed work from the lighter planned bar.

7. Review dependencies and maintain the schedule.

   Check whether each task can begin when planned. Add a predecessor column if one task depends on another, such as “Task 3” depending on “Task 2.”

   Look for overlapping work, unrealistic deadlines, and empty gaps between dependent activities. Then test the chart by changing one end date and checking whether the bar moves correctly.

   Finally, create a simple update routine. For example, review progress every Friday, adjust dates after approved changes, and record the reason for major schedule shifts in a notes column.

How the Gantt Chart Formula Works

The visual bar appears when two conditions are true: the calendar date is on or after the task’s start date, and it is on or before the task’s end date.

The formula checks those conditions with AND:

=AND(H$1>=$D2,H$1<=$E2)

Imagine a task running from March 4 through March 8. The chart checks each timeline date. March 3 returns false, March 4 through March 8 return true, and March 9 returns false.

Here’s the practical effect: every true result receives the selected fill color, creating a horizontal bar across the task row.

Common formula mistakes

The most common mistake is referencing the wrong row or column. If your start date is in column E instead of D, update the formula accordingly:

=AND(H$1>=$E2,H$1<=$F2)

Another frequent issue is using text that looks like a date. If Google Sheets treats “03/04/2026” as plain text, comparisons may fail. Reformat the cell as a date and re-enter the value.

If all rows show the same bar, check whether the row reference is fixed incorrectly. The task row should normally remain relative, as shown by the number without a dollar sign in $D2.

How to Add Milestones, Dependencies, and Today’s Date

A simple bar chart becomes more useful when it shows important events and schedule risks. You can add these details without rebuilding the entire layout.

Mark milestones

A milestone usually has no duration. Examples include “Contract signed,” “Design approved,” and “Launch day.” Give the milestone the same start and end date.

Then create a separate conditional formatting rule for milestone rows. You can use a different color, bold text, or a symbol in the task name, such as “◆ Launch day.”

Show task dependencies

Add a predecessor column to identify the work that must happen first. For example, “Build landing page” may depend on “Approve copy.”

This column will not automatically draw dependency arrows. However, it gives your team a quick way to identify sequencing problems. If the approval task moves later, review every connected task before keeping the original dates.

Highlight today

To mark the current date, add another conditional formatting rule to the timeline:

=H$1=TODAY()

Choose a contrasting border or background color. The marker will move automatically each day, making overdue and upcoming work easier to spot.

How to Make the Chart Easier to Read

A technically correct chart can still fail if people cannot scan it quickly. Prioritize a clear task hierarchy, readable dates, and a consistent color system.

Use summary tasks

Group detailed tasks under larger phases such as “Planning,” “Design,” “Development,” and “Launch.” Use a stronger color for summary rows and lighter colors for the activities below them.

For example, a “Website redesign” phase might contain research, wireframes, visual design, development, testing, and release tasks.

Keep colors meaningful

Assign one color to planned work, another to completed work, and a warning color to blocked activities. Avoid giving every person a different color unless ownership is the main thing you need to track.

A small legend near the top of the chart can prevent confusion. Keep it short so it does not compete with the schedule.

Limit unnecessary detail

Do not place every tiny action on the main timeline. A task such as “Send one reminder email” may not deserve its own bar in a six-month schedule.

Instead, track meaningful deliverables and use a notes area for smaller actions. This keeps the chart useful during planning meetings.

When Google Sheets Is a Good Choice

Google Sheets works well when you need a lightweight visual schedule for a small team, a short project, or a planning session. It is especially convenient when collaborators already work in Google Workspace.

For example, a five-person event team planning a three-week conference can use one chart for venue preparation, speaker coordination, promotion, and event-day activities.

The approach also works when the schedule changes occasionally rather than constantly. A project lead can update dates, review the chart, and share the latest view without introducing a complex workflow.

The best part? You can start quickly and adapt the layout to your project. You control the columns, labels, colors, and formulas.

When a Dedicated Project Management Platform Makes More Sense

Google Sheets becomes harder to manage as the number of tasks, contributors, and dependencies grows. Manual updates can create conflicting versions, unclear ownership, and stale progress indicators.

Consider a dedicated platform when several people update work every day, tasks depend on one another, or leaders need reports without manually preparing them.

For example, a product launch involving engineering, marketing, legal review, and customer support may need several connected views. Each group needs its own work area, while leadership needs a reliable project summary.

Let me explain: a Gantt chart is excellent for showing time. A project management system can connect that timeline with ownership, workflows, approvals, discussions, reporting, and ongoing execution.

A More Scalable Gantt Chart Solution: ONES.com

ONES.com combines project management and knowledge management in one platform powered by ONES Assistant. ONES Project serves as a Jira alternative for planning and delivery, while ONES Wiki provides a Confluence alternative for organized team knowledge. They are sold separately.

If your schedule has outgrown manual formulas, ONES.com can help you manage the work behind the timeline. You can use it in the cloud, on-premise, private cloud, or an air-gapped environment. The free plan supports up to 30 seats, and self-hosted deployments offer feature parity with the cloud version.

Core capabilities

1. Rebuilding schedules after repeated changes

Pain: A date change in Google Sheets may require manual edits across several rows and calendar cells.

ONES capability: ONES Project supports structured project plans, task relationships, custom fields, and Jira-compatible workflows.

Result: Your team can adjust work within a connected project structure instead of maintaining formulas by hand.

2. Losing track of task ownership

Pain: A colored bar may show timing without making responsibility obvious.

ONES capability: Assign tasks to team members, add statuses, and use custom fields for ownership, priority, risk, or department.

Result: Each activity has clearer accountability and can be filtered by the people responsible.

3. Managing complex delivery cycles

Pain: Large projects often contain approvals, handoffs, reviews, and exceptions that a simple chart cannot represent well.

ONES capability: Custom workflows and automation support repeatable project processes.

Result: Work can move through defined stages with fewer manual reminders and less ambiguity.

4. Tracking progress across multiple projects

Pain: Separate Google Sheets make portfolio-level visibility difficult.

ONES capability: Built-in reporting helps bring project progress, status, and activity into a more consistent view.

Result: Managers can identify delays and competing priorities without opening every schedule individually.

5. Relying on too many plugins

Pain: Additional integrations can increase setup effort, maintenance, and points of failure.

ONES capability: ONES Project includes native project planning, sprint management, reporting, automation, custom workflows, and custom fields.

Result: Teams can reduce dependence on separate add-ons for routine project operations.

6. Recreating familiar Jira workflows

Pain: Teams may want a Jira alternative without abandoning familiar delivery practices.

ONES capability: ONES Project supports Jira-compatible workflows and sprint management.

Result: Teams can move to a different platform while preserving established planning and development patterns.

7. Keeping restricted projects private

Pain: Some organizations cannot place project information in a public cloud environment.

ONES capability: ONES.com supports on-premise, private cloud, and air-gapped deployments.

Result: Teams can use project management workflows in restricted environments while maintaining control over access and deployment.

8. Separating project work from team knowledge

Pain: Project decisions and working guidance can become difficult to find when they are scattered across conversations and separate systems.

ONES capability: ONES Wiki provides a knowledge management space alongside ONES Project.

Result: Teams can connect delivery activities with reusable guidance, procedures, and project context.

Application scenarios

Software release planning: A product team can manage epics, sprints, testing, approvals, and release tasks through structured workflows. Reporting gives stakeholders a clearer view than a manually colored calendar.

Marketing campaign coordination: Marketing, design, legal, and sales can share a project plan with owners, approval stages, and deadlines. Custom fields can identify campaign channels, priority, and launch region.

Restricted engineering work: An engineering organization operating in an air-gapped environment can use a self-hosted deployment for planning, sprint management, reporting, and controlled collaboration.

Common Challenges and Practical Solutions

Challenge 1: Dates display incorrectly

Problem: A chart may show empty bars because dates are treated as text.

Solution: Select the date range, choose Format > Number > Date, and re-enter any values that still do not behave like dates. Test one row before applying the rule to the whole chart.

Challenge 2: The timeline becomes too wide

Problem: Daily columns can make a long project difficult to navigate.

Solution: Use weekly columns for projects lasting several months. Keep a separate detailed planning area for short-term daily work.

Challenge 3: The chart becomes visually crowded

Problem: Too many colors, columns, and task rows make the schedule hard to scan.

Solution: Display major deliverables on the main view, group related work into phases, and move supporting details into notes or a separate planning area.

Challenge 4: Progress becomes outdated

Problem: The bars may reflect the original plan while actual work has moved elsewhere.

Solution: Set a recurring update time. Ask each owner to update status and progress before the weekly review, then discuss exceptions rather than reading every row aloud.

Challenge 5: Dependencies remain hidden

Problem: Two bars can appear to overlap even though one task cannot begin until the other finishes.

Solution: Add a predecessor column and review dependency chains during planning. If the project is dependency-heavy, consider a platform that connects task relationships to workflow automation.

FAQs

Can I create a Gantt chart in Google Sheets without a template?

Yes. You can build one manually with task rows, start and end dates, a calendar timeline, and conditional formatting. The key formula compares each timeline date with the task’s start and end dates. Templates can save setup time, but creating the chart yourself helps you understand how to adjust colors, progress rules, milestones, and weekly views.

What formula colors a task bar in Google Sheets?

A common custom formula is =AND(H$1>=$D2,H$1<=$E2). This assumes the timeline dates are in row 1, the task start date is in column D, and the task end date is in column E. Change the cell references if your layout uses different columns or rows.

How do I show progress in a Google Sheets Gantt chart?

Add a progress column with percentage values, then create a second conditional formatting rule for the completed portion of each task. You can also use status labels such as “In progress,” “Blocked,” and “Complete.” Different colors make planned work and completed work easier to distinguish during reviews.

Can I add dependencies to a Google Sheets Gantt chart?

Yes. Add a predecessor column that identifies the task required before each activity can begin. Google Sheets will not automatically draw dependency arrows in a basic setup, so you must review the relationships manually. For projects with many linked tasks, a dedicated project management platform may provide clearer dependency handling.

Should I use daily or weekly timeline columns?

Use daily columns for short projects where exact dates matter, such as a two-week event launch. Use weekly columns for longer schedules because they keep the chart compact and easier to scan. You can maintain daily planning separately when the team needs more detail during execution.

Conclusion

You can make a useful Gantt chart in Google Sheets by organizing tasks, entering start and end dates, building a calendar row, applying conditional formatting, adding progress, and reviewing dependencies.

The method works well for small teams and straightforward schedules. Keep the layout simple, use meaningful colors, and establish a regular update routine so the chart remains trustworthy.

But here's the truth: manual charts become harder to maintain as projects gain more contributors, dependencies, approvals, and reporting needs. When that happens, ONES.com offers a more structured path through ONES Project, optional ONES Wiki, built-in reporting, automation, custom workflows, sprint management, and flexible deployment choices.

Start with Google Sheets when speed and simplicity matter. Move to a dedicated platform when your project needs connected execution rather than a visual schedule alone.