How to Create an Awesome Gantt Chart in Google Sheets

Подписаться 6 тыс.

Просмотров 5 тыс.

50% 1

Learn how to build an awesome Gantt Chart in Google Sheets!
SPREADSHEET LINK
spreadsheetlife.com/templates...
COURSES
spreadsheetlife.com/all-courses/
OTHER
Templates: spreadsheetlife.com/templates/
Blog: spreadsheetlife.com/blog/
VIDEO CHAPTERS
00:00 - Intro
00:45 - Structure
04:28 - Formatting
06:26 - Formulas
12:55 - Conditional Formatting
20:58 - Expanding the Chart
22:28 - Outro
MUSIC TRACK
Track: Melted Mind
Artist: Max Anson
Music provided by Epidemic Sound

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@TeriKennedy-do5kv Месяц назад

Great simple step by step for all Gantt items. Thx!

@spreadsheetlife Месяц назад

😄😊👍

@ManiTOOR-g9l 9 дней назад

Hillarious full of knowldge

@spreadsheetlife 8 дней назад

😅😊👍

@tal7atal7a66 4 месяца назад

hello bro , hope you're doing well , ❤ it's been long time i didn't see your Chanel notif i the 🔔 section. thank you bro , excellent tutos/ explainations as always ❤

@spreadsheetlife 4 месяца назад

Thank you so much. I'm doing awesome, and trying to enjoy each and every day as much as I can. Hope you're doing great too! So glad that you enjoyed this video and that it lives up to my previous ones. I'll do my best to keep it coming! 😄👍

@fifteenmin 2 месяца назад

Great video, thank you!! What changes would I make to the formula if I wanted to keep weekends in the calculation?

@spreadsheetlife 2 месяца назад

Great question. To keep the weekends, just subtract the two dates instead of using the WORKDAYS function. I hope this helps.

@androidmuncher 26 дней назад

@@spreadsheetlife Would you mind explaining what the the formula would look like? Great video by the way!

@spreadsheetlife 26 дней назад

Thank you so much. I'm glad you enjoyed the video! And yes, the formula would look like this. =IF(ISBLANK(E6),"-",E6+F6-1)

@widyanakbar 3 месяца назад

hi, quick question. when I do the 8:39 it doesn't say error or anything. but the bar chart is not there. how to fix this issue? thank you

@widyanakbar 3 месяца назад

I found the answer, my google sheet require this line: =IFERROR(SPARKLINE(H6;{"charttype"\"bar";"max"\1});"")

@spreadsheetlife 3 месяца назад

It's difficult to say without more context. You are welcome to send me an email at info@spreadsheetlife.com with a screenshot or possibly a link to your spreadsheet so far so I can take a look at it for you.

@Firzj Месяц назад

16:30 this formula doesn't work for me. I've adapted cells for my sheet but it returns formula parse error. In the preview of the formula only the cells with start/end dates are selected. It doesn't recognize cells which are above TRUE as in the video

@spreadsheetlife Месяц назад

How fascinating. If you'd like, you can share your spreadsheet or send me screenshots at info@spreadsheetlife.com, and I can more easily help there.

@Firzj Месяц назад

@@spreadsheetlife thanks, I solved the problem with Chatgpt. I changed , to ; and it works now. Dunno why google doesn't understand that formula maybe they updated something

@spreadsheetlife Месяц назад

Oh that's awesome! I'm glad you figured it out. If you're curious why you had to use a semi-colon instead, check out this article. spreadsheetlife.com/how-location-affects-formula-syntax-in-google-sheets/

@Seducier 20 дней назад

I ended up not using the last function where the colored days correlate with the sparkline %, instead I made the bars match the color of the assignees. :) ty for tutorial

@spreadsheetlife 20 дней назад

How interesting. I love seeing how everyone puts their own spin on things! 😄 I'm glad you enjoyed the tutorial!

@user-rd6cm1qd2t 4 месяца назад

How can I add a late column 5:I?

@spreadsheetlife 4 месяца назад

To add a column in Google Sheets, select the column where you want to add one, right-click, and insert a new column to the right or left. Let me know if this helps.

15:29

How to Make a Mobile Expense Tracker in Google Sheets

Просмотров 3,3 тыс.