***** FAQ ***** I probably won't have time to answer specific questions, but I'll use this comment for some common questions. If you have problems getting things to work, see the link in the first paragraph of the description to download the template. 0. I can't get [fill in the blank] to work. Have any advice? Make a copy of the template for Google Sheets, accessible via the following page and analyze the template to figure out how it's done: www.vertex42.com/ExcelTemplates/simple-gantt-chart.html 1. How do I ignore weekends? See the related video series for Excel. Similar techniques and formulas can be applied in Google Sheets: ruclips.net/video/5or9BN3GanM/видео.html 2. 10:12 - The correct shortcut for grouping rows is SHIFT+ALT+RightArrow 3. How do I display monthly instead of daily/weekly? See the answer to #1 4. How do you show milestones? If you mean showing the diamond symbol (◆) within the chart, you can do that using formulas within the cells of the chart to display the unicode diamond character. I use that technique in Gantt Chart Template Pro (not free) but it appears more like magic because of the use of spilling array formulas. If you want to display a milestone as a just a different color, that is much easier and see the answer to #1 for a video that shows changing the colors.
Some people don't need to spend $50/month for project management tools and all they need is a simple Gannt chart to track their tasks. You just saved everyone so much money. You're awesome! What a great video
Can I just say this is probably one of the best tutorial videos I've ever seen on youtube. Simple, easy to understand, straightforward, good video quality, not too long. It goes over each procedure in a way that is easy to understand and doesn't over explain. Learned so much from this one video. Thank you, I hope you make more videos in the future.
This tutorial is honestly one of the best I've ever seen for making material relatable and interesting. The entire video passed without me being pulled away to check email/focus on another project because I was engrossed. The use ofgraphics and motion really helps guide the eye and maintain interest, the music choice was unobtrusive but assisted in maintaining interest, and the visual of the shortcut keys was brilliant! Thank you!
@@vertex42 Do you have a video teaching how to make a linked subtask within the chart? The way I see it is the phase/task but I'm not sure how to make it make sence to create a phase/task/subtask.I know I'm going to add a column where I can assign subtasks to resources, if I can figure out how to set up the subtasks w/in this chat. I appreciate what youve' created!
Wow, what a video: awesome display of skills both with sheets and with video creation. Good speed, good audio, great sheets knowledge applied to Gantt Charts. No wasted time, no unnecessary redundancies. Excellent. Thank you so much.
You have no idea, how much this has helped me out. Working on multiple projects that are very large and complex with very long timelines. This made it easy for me to wrap my head around all of it and clearly communicate that to the team. Thank you very very much for your work! Much love and appreciation.
Hi Bob, How did you add your multiple projects? Example, let's say you had a dozen. Did you put them all into sheet one, or use one new sheet per project? I would love to know how to make multiple overlapping projects (you know, every manager's situation!) be visually represented as such--All happening at once! Thanks in advance! Brady
Takes me back. In 1980 we opened a Radio Shack Computer Center and everyone knew nothing about PC's and the company had nobody to train us, so we learned by doing. One young lad, a jerk who didn't like sharing, had found out how to make a simple formula (location = location above + 1) then he selected it and did a smear for where to copy it and hit enter. It was like magic, as the number 1 became a sequence down the page. "How did you do that?" we all asked, as we knew only how to type numbers in cells and noting about formulas or copying them. "Figure it out yourselves". I did and thus a career in computers was born, though I thought the kid who wouldn't share was a jerk. He didn't last long, but I did. How? By doing what I am going here, like you. Setting myself a task then finding others who know how to do it to learn from them. Humility and curiosity never wear out though my brain is a little slower after 42 years.
This was BY FAR THE ABSOLUTE BESTTTT explanatory video i have seen in my entire life. I am stunned at how easy and well it was all explained, i did it perfectly.
Excellent video. Too many people who post on YT, simply wing-it with pauses, mistakes, and other wastes of the viewer's time. Your technique is flawless.
What a well-explained tutorial! I managed to easily create a Gantt chart like the one in the tutorial and now motivation surges from within to learn more functionality of Google Sheets, which I didn't expect to be almost as powerful as Excel.
Greatest. Instructional video. Ever. I had no idea Google Sheets did all of this!!! My team has so many projects that we can use these charts for. I legitimately cannot thank you enough!!!
You have no idea how helpful all your videos are. They have helped me tremendously at work. Thank you for making this amazing material available for free. I am eternally grateful!!!
This is awesome! I have a bunch of software already for my company and really didn't want to add on another subscription just for scheduling. This is invaluable and will help me a ton in future projects thank you for posting such a great, comprehensive guide on building it!
Hey I just want to say BIG THANK YOU! Your template and your tutorials are just BEYOND AMAZING. You have helped so many people and I really appreciate your work (slash kindness!) :)
Where have you been for all these years?! This tutorial will be useful to ALL SPREADSHEET Beginners! I hope you'll continue this kind of knowledge sharing. Godbless you! 😍😭♥️
Thank you for actually providing a guide to create a dynamic Gantt chart within google sheets. I can't wait to begin using this for my upcoming projects!
I went into this video hoping I could make a Gantt chart on my own, and you made that possible. Thank you for giving me more confidence with Google Sheets!
This is really helpfull, i struggle with keeping up on the task i had since i need to work, study, and freelancing. There are times when i focus at one task and forget about another task. I did write my task but sometimes i just forgot the deadline. This tracker help me a lot.
This is a great video learning about Gantt in Google sheets. I finished my Gantt Chart but noticing this is considering saturday and sunday which is not good for my project, now I'm working with WORKDAY function.
Sorry if it's here already somewhere but "Group" now lives under the "View" tab, unless you are doing a "Group by filter" view (which is still under data). Also, I know it's in the updated comment, but shortcut for grouping rows is SHIFT+ALT+RightArrow. This is a tremendously informative video. Thank you!!
This is so fantastic! I only have a little knowledge in using google sheets but with your work this helps me a lot. Thank you so much and I hope you continue in giving tutorials to those like us.
Awesome training tutorial!! I was able to create my tracker in no time, this was super easy to follow, nicely explained and great visuals to see what's going on. Thank you so much for putting this together!!
I’m not gonna lie, I went around with some shortcuts to put weeks (since my design project was from Feb-May) but this helped me out so much. It was fun learning new formulas and creating an amazing Gantt Chart!!
honestly have never made a gantt chart and i was so scared to make one when my supervisor asked me. Usually videos like these are really boring and complicated, but i like this one cause its straightforward
Thank you so much! I learned so much. Very helpful. I like how you built up a base chart and then added functionality. Also, you're showing all of the various functions was super helpful - especially how you would take a base function and then modify it - this made it helpful for me to not get overwhelmed as I learned.
Thank you so much! I'm into the third week of my new job and needed better project management for the team and myself. I really appreciate the clear and concise lesson.
THANK YOU SOOOO MUCH!!! I have a project in school, where I must make this chart. I don't like Excel (internet version), but Google Sheets seems ok. One more time - THANK YOU MAN:)
This is truly one of the best follow along tutorial i ever used. I got mine magically done within the duration of your video. kudos man! like and sub !
I'm in literal excitement over the "group" element. Thank you so much for teaching us this step by step, as always, well done! I've been intimidated by Gantt charts and you explained everything so well. Excited to get started using this.
awesome! although the only formula I didn't know is sparkline, it was great to see how much you can create on so few formulas. sometimes I struggle to create things in a simpler way and I think this video is a great example on how to do it.
amazing video. and being able to operate in google sheets is great. I bought one template and realized quickly I HAD to buy Microsoft office to even use it
Awesome video, you have save my day !! Also, if y'all have tumble with the progression bar (SPARKLINE(C8;{"charttype"\"bar";"color1"\"green";"max"\1}))Worked for me ;)
Alhamdulillah, this was an excellent video I've ever seen (ignoring the bg music). I've learnt about the template and also some formulas of excel/spreadsheet.
Wow! Simply one of the best and simple tutorials I immediately want to try out. I was actually looking for a simple gsheet task tracker that fits my particular needs but I learned some very helpful features here that I can apply to my task tracker instead of trying to customize a template I previously found. If there is a good gsheet tutorial that can track tasks and do multiple levels of filtering for data like in Excel, I'm all ears!
Very informative and detailed. Thank you very much for the entire series. I could prepare my Gantt chart and present it well further. You have very good presentation and teaching skills. It was very easy to follow. Thank you once again.
***** FAQ ***** I probably won't have time to answer specific questions, but I'll use this comment for some common questions. If you have problems getting things to work, see the link in the first paragraph of the description to download the template.
0. I can't get [fill in the blank] to work. Have any advice? Make a copy of the template for Google Sheets, accessible via the following page and analyze the template to figure out how it's done: www.vertex42.com/ExcelTemplates/simple-gantt-chart.html
1. How do I ignore weekends? See the related video series for Excel. Similar techniques and formulas can be applied in Google Sheets: ruclips.net/video/5or9BN3GanM/видео.html
2. 10:12 - The correct shortcut for grouping rows is SHIFT+ALT+RightArrow
3. How do I display monthly instead of daily/weekly? See the answer to #1
4. How do you show milestones? If you mean showing the diamond symbol (◆) within the chart, you can do that using formulas within the cells of the chart to display the unicode diamond character. I use that technique in Gantt Chart Template Pro (not free) but it appears more like magic because of the use of spilling array formulas. If you want to display a milestone as a just a different color, that is much easier and see the answer to #1 for a video that shows changing the colors.
Not only did I learn Gantt Chart, I learned the whole google sheet application from this vid. So many features I didn't know existed
Some people don't need to spend $50/month for project management tools and all they need is a simple Gannt chart to track their tasks. You just saved everyone so much money. You're awesome! What a great video
Can I just say this is probably one of the best tutorial videos I've ever seen on youtube. Simple, easy to understand, straightforward, good video quality, not too long. It goes over each procedure in a way that is easy to understand and doesn't over explain. Learned so much from this one video. Thank you, I hope you make more videos in the future.
What 5 people disliked this video? A free service that is brilliantly done and offers nothing but help. I despair for humanity.
Nerd
yeah
Microsoft Projects disliked. We can't have free things.
They are confused, they were trying to download the video. Awesome tutorial!!!
There's always negative Nelly's out there.
This tutorial is honestly one of the best I've ever seen for making material relatable and interesting. The entire video passed without me being pulled away to check email/focus on another project because I was engrossed.
The use ofgraphics and motion really helps guide the eye and maintain interest, the music choice was unobtrusive but assisted in maintaining interest, and the visual of the shortcut keys was brilliant!
Thank you!
Thank you!
@@vertex42 Do you have a video teaching how to make a linked subtask within the chart? The way I see it is the phase/task but I'm not sure how to make it make sence to create a phase/task/subtask.I know I'm going to add a column where I can assign subtasks to resources, if I can figure out how to set up the subtasks w/in this chat.
I appreciate what youve' created!
Wow, what a video: awesome display of skills both with sheets and with video creation. Good speed, good audio, great sheets knowledge applied to Gantt Charts. No wasted time, no unnecessary redundancies. Excellent. Thank you so much.
You have no idea, how much this has helped me out. Working on multiple projects that are very large and complex with very long timelines. This made it easy for me to wrap my head around all of it and clearly communicate that to the team.
Thank you very very much for your work! Much love and appreciation.
Hi Bob, How did you add your multiple projects? Example, let's say you had a dozen. Did you put them all into sheet one, or use one new sheet per project? I would love to know how to make multiple overlapping projects (you know, every manager's situation!) be visually represented as such--All happening at once! Thanks in advance! Brady
Takes me back. In 1980 we opened a Radio Shack Computer Center and everyone knew nothing about PC's and the company had nobody to train us, so we learned by doing. One young lad, a jerk who didn't like sharing, had found out how to make a simple formula (location = location above + 1) then he selected it and did a smear for where to copy it and hit enter. It was like magic, as the number 1 became a sequence down the page.
"How did you do that?" we all asked, as we knew only how to type numbers in cells and noting about formulas or copying them.
"Figure it out yourselves".
I did and thus a career in computers was born, though I thought the kid who wouldn't share was a jerk. He didn't last long, but I did.
How? By doing what I am going here, like you. Setting myself a task then finding others who know how to do it to learn from them. Humility and curiosity never wear out though my brain is a little slower after 42 years.
This was BY FAR THE ABSOLUTE BESTTTT explanatory video i have seen in my entire life. I am stunned at how easy and well it was all explained, i did it perfectly.
Excellent video. Too many people who post on YT, simply wing-it with pauses, mistakes, and other wastes of the viewer's time. Your technique is flawless.
What a well-explained tutorial! I managed to easily create a Gantt chart like the one in the tutorial and now motivation surges from within to learn more functionality of Google Sheets, which I didn't expect to be almost as powerful as Excel.
Greatest. Instructional video. Ever.
I had no idea Google Sheets did all of this!!!
My team has so many projects that we can use these charts for. I legitimately cannot thank you enough!!!
You have no idea how helpful all your videos are. They have helped me tremendously at work. Thank you for making this amazing material available for free. I am eternally grateful!!!
Thank you. It took me time but I finally did it. Thank you. I hope one day I am also resourceful for the community.
This is awesome! I have a bunch of software already for my company and really didn't want to add on another subscription just for scheduling. This is invaluable and will help me a ton in future projects thank you for posting such a great, comprehensive guide on building it!
Hey I just want to say BIG THANK YOU! Your template and your tutorials are just BEYOND AMAZING. You have helped so many people and I really appreciate your work (slash kindness!) :)
My group are incredibly excel illiterate. So this not just boost my usefulness but cemented myself as a valuable assets.
Where have you been for all these years?! This tutorial will be useful to ALL SPREADSHEET Beginners! I hope you'll continue this kind of knowledge sharing. Godbless you! 😍😭♥️
I like that you added styling between explanation parts so that we concentrate, rest, then concentrate again
Thank you for actually providing a guide to create a dynamic Gantt chart within google sheets. I can't wait to begin using this for my upcoming projects!
Probably one of the best and most helpful things I've watched on RUclips. Thank you
I went into this video hoping I could make a Gantt chart on my own, and you made that possible. Thank you for giving me more confidence with Google Sheets!
This is really helpfull, i struggle with keeping up on the task i had since i need to work, study, and freelancing. There are times when i focus at one task and forget about another task. I did write my task but sometimes i just forgot the deadline. This tracker help me a lot.
bro.. you bring the internet in your best version, for human coordination -- thank you so much friend!
I am amazed how someone can explain so much in just 10 minutes!
Probably the most crisp and effective tutorial I watched on any subject, ever.
174.37% agree 👍 Bravo 👏
You're amazing. This is the most helpful tutorial I've ever watched in my entire life. So effective and entertaining too. Thank you so much!!!
OMG THIS VIDEO BLEW MY MIND, Excellent info, I had no idea this could be done in Sheets!!
Life saver! This is as straight to the point as it gets! Saved me £££ and the hassle of having to install software. Top lad! Cheers...
This was a lifesaver! So easy to follow and I can't believe I created my own chart. Stellar!
My first ever gantt chart and was able to follow through smoothly! Thank you so much!!!!
Your presentation is so good. You have ability to make complex subject easy to audience. Wish you a good health.
This is a great video learning about Gantt in Google sheets. I finished my Gantt Chart but noticing this is considering saturday and sunday which is not good for my project, now I'm working with WORKDAY function.
Perfect timing ... just published Part 2 today. :-)
This is really great! Well presented, excellent info. I've been using spreadsheets for decades but learned a lot from this video!
Thank you so much Vertex42. I just made my Gantt chart using your explanations and guidance. Very grateful.🙏🙏🙏🙏🙏
thank you for this. I have no idea how to create gantt chart and been struggling for couple of hours. BIG THANKS man!
I’ve been using google sheets for a while and I still learned an insane amount. Awesome tutorial!
Keyboard Shortcut to group rows is Alt+Shift+--> (not Ctrl+Shift as in the video). This was a life saver by the way!
Thanks for creating this spreadsheet! It would've taken me hours setting it up on my own, so much appreciated!
Wow. Subscribed! Vote for Best instructional video...even though it is now 2023! lol
Amazing tutorial! I loved that you explained what you were doing and why you were doing it. I learned A LOT in such a short amount of time.
Wow! That's the best training tutorial ever. I learned more in 10 minutes than never before. Thank you so much.
This is the best tutorial ever on google sheets! Thank you so so much! You are a savior!
EXTREMELY Helpful!! It is so fast, but using the pause button can help.
This is one of the best tutorial I have seen! Good job. Thank you.
This is a super g8 video...learnt and applied. Fact: I didn't know how to create a Gantt chart at all, just did one, thanks to you.
Thankyou very much for the detailed Explanation. This was my 1st Gantt chart and I enjoyed making this one.
Sorry if it's here already somewhere but "Group" now lives under the "View" tab, unless you are doing a "Group by filter" view (which is still under data). Also, I know it's in the updated comment, but shortcut for grouping rows is SHIFT+ALT+RightArrow. This is a tremendously informative video. Thank you!!
Amazing video, exactly what I needed, a bit quick for my pace but I just paused it every couple of minutes :)
Absolutely one of the BEST tutorials I have seen. Thank you, I learned a TON
I actually follow your steps and created my very own gant chart..Thanks again
This is so fantastic! I only have a little knowledge in using google sheets but with your work this helps me a lot. Thank you so much and I hope you continue in giving tutorials to those like us.
This is the best tutorial I've seen in a very long time. It's concise, interesting, and easy to follow. Great job!
Awesome training tutorial!! I was able to create my tracker in no time, this was super easy to follow, nicely explained and great visuals to see what's going on. Thank you so much for putting this together!!
I’m not gonna lie, I went around with some shortcuts to put weeks (since my design project was from Feb-May) but this helped me out so much. It was fun learning new formulas and creating an amazing Gantt Chart!!
honestly have never made a gantt chart and i was so scared to make one when my supervisor asked me. Usually videos like these are really boring and complicated, but i like this one cause its straightforward
This is the most beautiful thing i've watched in my entire life!
Yes, the BEST!!!
Thank you so much! Outstanding tutorial. Clear, concise, and to the point! Subscribed.
Thank you so much! I learned so much. Very helpful. I like how you built up a base chart and then added functionality. Also, you're showing all of the various functions was super helpful - especially how you would take a base function and then modify it - this made it helpful for me to not get overwhelmed as I learned.
This is my current format for my gantt chart.. Awesome Tutorial. Very informative and very easy to follow.
Thank you so much! I'm into the third week of my new job and needed better project management for the team and myself. I really appreciate the clear and concise lesson.
I was just in seeking of how to draw gantt chart but, you have teach alot in this video, thanks
THANK YOU SOOOO MUCH!!! I have a project in school, where I must make this chart. I don't like Excel (internet version), but Google Sheets seems ok. One more time - THANK YOU MAN:)
first time an educational youtube tutorial has been actually helpful from beginning to end. Thank you so much!
This is truly one of the best follow along tutorial i ever used. I got mine magically done within the duration of your video. kudos man! like and sub !
Thanks a lot. It was extremely helpful. Before the video, I was struggling for hours!!!
So nice tutor! Thank you so much to provide this nice video!
I wathched 5 times and did google sheets 3 times!
Great job!!!
Amazing tutorial!! Thank you sooooo much!!! I learned so much and can say confidently that I can now make my own Gantt chart!!!
That was a great video. Easy to follow and everything well explained. NICE!
Thank you!
This is so helpful thank you!!! I want to make my chart to exclude weekends, can you suggest how I can add this feature?
The visuals on this are incredible. Excellent timing as well.
THE BEST tutorial ever existed. THANK YOU!
Wow thank you! You went above and beyond just showing us how to make a Gannt Chart
the speed of the video is perfect, not too fast or too slow 👍
Amazing tutorial! I never knew I can do all this with google sheets
I'm in literal excitement over the "group" element. Thank you so much for teaching us this step by step, as always, well done! I've been intimidated by Gantt charts and you explained everything so well. Excited to get started using this.
Literally the most helpful Gantt chart video online!!! Tysm
this was the best tutorial video I've seen in a while. thannks!
awesome! although the only formula I didn't know is sparkline, it was great to see how much you can create on so few formulas. sometimes I struggle to create things in a simpler way and I think this video is a great example on how to do it.
amazing video. and being able to operate in google sheets is great. I bought one template and realized quickly I HAD to buy Microsoft office to even use it
Wow, this is the tutorial that I've been searching weeks for. Incredible guide
This Tutorial is just so useful and awesome ! NO regrets !
Awesome video, you have save my day !! Also, if y'all have tumble with the progression bar (SPARKLINE(C8;{"charttype"\"bar";"color1"\"green";"max"\1}))Worked for me ;)
Alhamdulillah, this was an excellent video I've ever seen (ignoring the bg music). I've learnt about the template and also some formulas of excel/spreadsheet.
Such a super tutorial. Thanks a lot! So hard to find a good and free Gant chart, and you make it easy to understand how to set it up.
Salamat kaayo Pareh, kay nanlisod jd ko sa among project management
Best video for Gantt Chart, to the point. Thank you
Thank you! This was one of the most useful videos with so many tips.
Wow! Simply one of the best and simple tutorials I immediately want to try out. I was actually looking for a simple gsheet task tracker that fits my particular needs but I learned some very helpful features here that I can apply to my task tracker instead of trying to customize a template I previously found. If there is a good gsheet tutorial that can track tasks and do multiple levels of filtering for data like in Excel, I'm all ears!
This might be the greatest video ever created
Just wow! so cool man! you've helped me a lot. Thank you, keep up the good work!
Very informative and detailed. Thank you very much for the entire series. I could prepare my Gantt chart and present it well further. You have very good presentation and teaching skills. It was very easy to follow. Thank you once again.
those mouse clicks sure are satisfying. thanks for the vid
This is the MOST Brilliant creation compared to many others. Start with this one.... You won't be sorry
Thank you so much for this step-by-step tutorial! I am very grateful and can now work on with planning various ongoing and upcoming projects!
All I needed was this one video to subscribe :D Very well explained :)
this is great!
is there an instructional on how to adjust it so that the unit isn't daily but weekly?
You are a GREAT instructor.
Wow! 🤗 You saved many hours of my time. It is so simple to color the Today's Line!! Thank you so much.