Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial

[@wannaberobert]

Very easy and most straightfoward sheet. You deserve more views. Thank you.

[@NeotechNavigators]

Most welcome

[@roymathew7956]

This is a very underrated video. I really like your use of the functionality in Google sheets-you’ve shown me a few things that I didn’t know.

[@NeotechNavigators]

Thanks for your valuable feedback

[@labelus9826]

Thank you so much, your method is easier than other videos!!

[@NeotechNavigators]

You're welcome!

[@SS19_96]

Thank you so much, it was very helpful and easy to follow!

[@NeotechNavigators]

Most welcome

[@LindsayWilson-e6f]

Super easy and great video! Thank you

[@NeotechNavigators]

Most welcome

[@GangaNair-y2b]

Very nicely explained

[@NeotechNavigators]

Thanks

[@TheGabriellepp]

Very helpful, many thanks

[@NeotechNavigators]

Most welcome

[@oddocid9734]

This is an awesome custom gantt!

[@SitiAisyah-lx4pt]

VERY HELPFUL! please do videos like this more often :D

[@NeotechNavigators]

Sure thanks

[@funZ00]

well expained. Thank You.

[@NeotechNavigators]

Most welcome

[@imranhosain8312]

Thanks a lot 😎

[@NeotechNavigators]

Most welcome

[@gabirabbit9470]

Gracias por compartir, excelente!!!

[@NeotechNavigators]

Most welcome

[@wojciechkazimierowicz7945]

Thanks a lot, had some problem with my gant scheduler, right now I got everything in the place working, atm I have to connect my e-agreement with zapier and my worksheet so it will automatically ad the projects 🎉

[@amiacat5321]

THANKSS MANNNN

[@NeotechNavigators]

Most welcome

[@anakbawang-skill6141]

Wonderful . Thank you so much

[@NeotechNavigators]

Most welcome

[@Md.SamiulIslamMonir]

Thank you so much sir.

[@NeotechNavigators]

Most welcome

[@chiomaojembe4343]

Thank you for sharing

[@NeotechNavigators]

Most welcome

[@pravin7891]

One of the best plan vs actual chart ....

[@NeotechNavigators]

Thanks

[@MattArma]

How to exclude saturday and sunday in the bar? For example, if the duration is 6 then the result is 1 week plus 1 day because it excludes the sat and sun.

[@LucyDowning-ib3eg]

Is it possible to turn the 'status' section into Milestones, to highlight if the task contributes to an end Milestone/ stage of the project?

[@nicolekageha]

How did you fill the dates after adding columns

[@amynelson6910]

Hi. Did you ever figure this out? I wanted to add more columns to the right but can't figure it out either. He didn't show that part.

[@teamsuksesdmi]

How come when I copy the formula, only one data appears to be successful, even though the data and dates are correct? What could be the solution?

[@Tkaggg]

I did the formula right the =IF(AND(F$5>=$E6,F$5

[@kritidhungel3523]

Same it’s not working for me as well

[@manufacturingprocesses8664]

=IF(AND(F$5>=$B6,F$5

[@Vhari52]

can't we do it on a normal excel sheet?

[@NeotechNavigators]

Yes we can

[@hunter2442]

the menu that you show when you right click is different than what I get, there is no drop down

[@NeotechNavigators]

Google sheets is updated by google. menu may be slighlty different.

[@bobbyousbob2936]

Saved my ass minutes to deadline🤣

[@kiddiescorner-jb5zy]

it was too fast i didnt understand