Events & Projects
Make a Free Copy in Google Sheets →
Free Project Timeline & Gantt Chart Template (Google Sheets)
Visual Gantt-style weekly timeline powered by conditional formatting and task completion percentages.
Ready-to-Use Google Sheets Workbook
Private copy in your Google Drive • Compatible with Excel (.xlsx)
Included Columns Structure
| Task ID | Phase | Task Name | Owner | Start Date | End Date | Duration (Days) | % Complete |
|---|---|---|---|---|---|---|---|
| Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry |
Ad Slot (In-Content Responsive Ad)
How to Set Up This Template
- Set your Project Start Date in the header cell.
- Enter tasks, owners, and start/end dates; the horizontal timeline bars highlight automatically.
Built-In Formulas Explained
-
NETWORKDAYSCalculates working business days between start and end dates, excluding weekends.
Frequently Asked Questions
Does this require any paid Google Workspace add-ons?
No, it uses 100% native Google Sheets formulas and conditional formatting.