How to build a Timeline Gantt Chart in Google Sheets

Timeline Gantt Charts stand as a powerful tool for tracking project timelines and tasks. I'm excited to guide you through the nuances of creating a Gantt Chart in Google Sheets, using conditional formatting to bring your project timelines to life.

I have a few powerful templates ready to go if you would like to skip straight to the desert. Both have an automatic Gantt Chart and lots of other bells and whistles.

Templates

Articles

Chapters
00:00 - Start
01:13 - Drop-down Labels
02:21 - Gantt Chart Dates
03:36 - Gantt Chart Conditional Formatting
07:35 - Gantt Chart Template

Social Channels

#ganttchart #gantt #todo #projectmanagement #dropdown #dropdownlist #Spreadsheet #GoogleSheetsTipsAndTricks #GoogleSheetsHacks #googlesheets #googlesheetstutorial #Spreadsheetwise

[neils]

What a clear and concise teacher you are. Thank you!

[lilianignatius]

You're Godsent! I have been battling with this particular issue and then realized that my first date was L5 instead of L4

[jaymeepadilla]

Super helpful! I immediately purchased this template.

[ChrisJones-miwi]

Thank you, I enjoyed this. Can you tell me more about, or share another video on how the check the status checkbox might affect the sheet and timeline? Also, how do you use and configure the Progress and Progress % columns?

[nooneremote]

very helpful. do you know how to do this with project management dependencies? Linking tasks together by WBS would be so helpful

[PamelaYammine]

Very helpful thank you but I have a question: why when I change the starting the date, the dates on the timeline change also? is there any way to keep it fix and the timeline do not change every time when I change the stating date?

[susanwoods-nattrass]

I purchase the template but as the status box is check, the project remains as opposed to automatically elliminating projects as the are checked off - how do I fix this?

[paulcostello]

Hi, how can I remove weekends and add in holidays to this please? thanks, Paul

[rosbkdf]

thanks for the Automatic Gantt Chart Template, i need help to make the Gannt chart based on months please

[carolynmendoza]

Hello, how do I change the timeline to read US date style? month/date/ year. Also full month dates not weeks. Thank you!

[antoniodzlo]

Hello thanks for you effort and work. If I add a task to futures, Excel does not automatically create columns. I'm a little lost here.

[vitobfr]

does it apply my conditional formatting when I create more rows?

[Firzj]

I don't know whats wrong but my custom formula doesn't work. Once I add new cells after comma inside brackets, it says invalid formula. for example =AND(G$1>=$D2) works ok, but if I continue adding like =AND(G$1>=$D2, G$1<=$E2, F2="Blue") it's not working.

[ilezcsv]

This is wonderful:) thanks alot. I'm looking for something similar just for an hours gantt chart, is your template suitable for that as well? do i have to create a new sheet for every day?

[fmylctp]

Hi, this is a great video. How would I exclude weekends and holidays in my chart?

[barclaybryan]

I tried the “And” conditional formatting; however, I presently only have the projected End Dates.
Without any end dates, the conditional formatting is applied to all cells in the first column.
And if I do not put in a start date but only the end dates, all cells in every row have the conditional formatting applied.

Is there a way to adjust the formula so that zero conditional formatting are applied if there are no start dates found?