Thank you. This was a lifesaver. Better the templates on Smartsheet and TeamGantt. Feedback, go a little slower on the formula part. I had to play with the code too, but figured it out.
This is a pretty good video overall but would have loved for you to explain the conditional formula part more for those that aren't as familiar with the logic and symbols.
This is cool. I utilized the formatting for shift hours and it worked well. I am wondering how you might be able to wrap this formatting into the hours past midnight problem?
Awesome video, works great thanks! One issue. The fill doesn't go to my last date. Eg my calendar goes until June 25th. Project end date is June 25th. That cell remains unfilled, fill stops on 24th. Tested many times on different months - if project is last day of specified time period does not fill
Though I couldn't sharply see the screen hence neither the numbers (probably my cheap computer), couldn't always understand your English (probably 'cause I am Spanish speaker) but I liked your expertise, thank you!
I use the Gantt project planner template and I would like to use 3 different colours for each task in my project. How can I combine formula = plan with conditional formatting that contains the name of my task?
First thanks for this educational video...My question is : How we can add a vertical line as defining todays date to that gantt chart?For example can we make an extra conditional formatting for todays date as vertical?and how?
Hi Semih, you can watch my other Gantt Chart video to dynamically mark cells based on specific criteria. It is much more easier to follow and to customize. Br.
hi Kumar, the easiest way is to add one row above dates, merge every 7 days, put a formula to get the weeknum in that cell =weeknum(date) and then copy the merge cells to the end of the row. You can hide day date cells or make date fonts to be similar with its background. Best regards.
hi Kumar, you can visit my site. there is a free inventory spreadsheet that should meet your need. You can learn the formula inside the spreadsheet as well. Best regards.
Great Video clip! Forgive me for the intrusion, I would appreciate your initial thoughts. Have you heard the talk about - Weydaniel Organized Dominator (do a google search)? It is a good exclusive guide for getting 7000 plus project management and business templates without the hard work. Ive heard some amazing things about it and my best friend Jordan at very last got astronomical results with it.
It is used to find dates in date columns that are not empty, above or similar with the start date and below or similar with the end date. best regards.
Thanks for the video content! Sorry for chiming in, I would appreciate your opinion. Have you heard the talk about - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a smashing exclusive guide for getting 7000 plus project management and business templates without the normal expense. Ive heard some interesting things about it and my work buddy at last got cool results with it.
hi Michael, those codes are working well. But, you still need to check your excel function format to make sure that you write the codes in correct format. Regards.
how do you exactly do this in the correct format? i can't get it. i still got an error if iam triying to copy your codes. iam from germany does that effect your codes? because of a different version of exel?
Useless and impractical..The 'schedule' does not include holidays and weekends. Shabby presentation- the conditional formatting is not visible..how can anyone follow along ???
This is glorious, I been tryin to find out about "project management forms and templates" for a while now, and I think this has helped. Have you heard people talk about - Biycarlett Astounded Builder - (Have a quick look on google cant remember the place now ) ? It is a smashing exclusive guide for discovering how to download thousands of business and project management templates minus the hard work. Ive heard some super things about it and my mate got great results with it.
This is just superb, been searching for "how do you write a project plan document?" for a while now, and I think this has helped. Have you ever come across - Biycarlett Astounded Builder - (just google it ) ? It is a good one of a kind guide for discovering how to download thousands of business and project management templates minus the normal expense. Ive heard some interesting things about it and my neighbour got great results with it.
Thank you very much for the tutorial. This is one of the best explained in cell Gantt chart tutorials I have viewed on RUclips.
Thanks Man, really you made my day!!!
I am supposed to send a project plan today and sent bcz of this video. Thanks again.
This is indeed a great way to understand dynamic task bar in Gantt Chart. I was struggling all this while with sample templates. Thank you so much :)
I had to modify some things but very very very happy to find something working and understudable ^^ Thanks a lot
Thank you. This was a lifesaver. Better the templates on Smartsheet and TeamGantt. Feedback, go a little slower on the formula part. I had to play with the code too, but figured it out.
This is a pretty good video overall but would have loved for you to explain the conditional formula part more for those that aren't as familiar with the logic and symbols.
Amazing man, great knowledge.
Thanks
Cheers mate, brilliant video
Excelente mr.
hehe... keren mas tutorialnya.... to the point... mantappp...
Very simplistic and effective video. Thank you! I first used the bar chart, but as I added items/sub-items it crushed my Gantt chart.
This is cool. I utilized the formatting for shift hours and it worked well. I am wondering how you might be able to wrap this formatting into the hours past midnight problem?
Very valuable thanks so much
thank you a lot
thanks a lot for your help
this is fantastic! Many thanks
In case you want to color code the bars by "Assignment", would you please suggest the respective formula? Best regards
Awesome video, works great thanks! One issue. The fill doesn't go to my last date. Eg my calendar goes until June 25th. Project end date is June 25th. That cell remains unfilled, fill stops on 24th. Tested many times on different months - if project is last day of specified time period does not fill
Though I couldn't sharply see the screen hence neither the numbers (probably my cheap computer), couldn't always understand your English (probably 'cause I am Spanish speaker) but I liked your expertise, thank you!
Nice video
thanks for the video, could you help with a formula you had used for conditioning
slightly different but you can also try this code
=if(and(H$9>=$E10;H$9
Hi good useful one you need to improve on my point of view is how we could avoid weekend
I use the Gantt project planner template and I would like to use 3 different colours for each task in my project. How can I combine formula = plan with conditional formatting that contains the name of my task?
Nice solution
In case someone is using Excel on MacOS heres the formula: =AND($E10"";$F10"";+H$9>=$E10;H$9
very good
First thanks for this educational video...My question is : How we can add a vertical line as defining todays date to that gantt chart?For example can we make an extra conditional formatting for todays date as vertical?and how?
Hi Semih, you can watch my other Gantt Chart video to dynamically mark cells based on specific criteria. It is much more easier to follow and to customize. Br.
Thank you! It helped me too much.
Thank you so much, can you please advise week wise gantt char in excel
hi Kumar, the easiest way is to add one row above dates, merge every 7 days, put a formula to get the weeknum in that cell =weeknum(date) and then copy the merge cells to the end of the row. You can hide day date cells or make date fonts to be similar with its background. Best regards.
Exceltemplate.NET thanks will try, can you advise any best format for store inventory in,out,issued,balance in 1 sheet
hi Kumar, you can visit my site. there is a free inventory spreadsheet that should meet your need. You can learn the formula inside the spreadsheet as well. Best regards.
Hallo, thanks for this chirt and very helpful, could you send other vidio showing with borh planned and actual activities pls
thanks
hey this looks great. I was tryin go find those who know how to make a "Track" where u enter today date and it show you a line what today is.
Hi, you can watch my other Gantt Chart tutorial where it will give you other method to show custom markers inside the Gantt Chart.
The conditional formatting is not working for me
I made the horizontal scale of 5 min interval, but the problem is when the date changes. Its not showing in the gantt chart. what to do??
Time has different format. You need to divide the minutes with (24 hour * 60 minutes) = time + minutes/(24*60) to get new time value.
sir what is the formula you typed?can you reply that formula here?
cant see what you are typing in as the formula? Prob important to show this?
hi there I also have problem With this code=and($E10"",$F10"",+H$9>=$E10,H$9
Check format in rule. "Fill" color in cell. It will help you. By mistake we change font color instead of fill color..
Great Video clip! Forgive me for the intrusion, I would appreciate your initial thoughts. Have you heard the talk about - Weydaniel Organized Dominator (do a google search)? It is a good exclusive guide for getting 7000 plus project management and business templates without the hard work. Ive heard some amazing things about it and my best friend Jordan at very last got astronomical results with it.
how did u copy horizontally in 1:29 of your video
can you please explain me the formula ? ($E10"",$F10"",H$9>=$E10,H$9
It is used to find dates in date columns that are not empty, above or similar with the start date and below or similar with the end date. best regards.
could you upload the file for us ? Many thanks for great Video
Thanks for the video content! Sorry for chiming in, I would appreciate your opinion. Have you heard the talk about - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a smashing exclusive guide for getting 7000 plus project management and business templates without the normal expense. Ive heard some interesting things about it and my work buddy at last got cool results with it.
Sir please different color
whats the code that works?
hi Michael, those codes are working well. But, you still need to check your excel function format to make sure that you write the codes in correct format. Regards.
how do you exactly do this in the correct format? i can't get it. i still got an error if iam triying to copy your codes. iam from germany does that effect your codes? because of a different version of exel?
Check format in rule. "Fill" color in cell. It will help you. By mistake we change font color instead of fill color..
thanks...
Useless and impractical..The 'schedule' does not include holidays and weekends.
Shabby presentation- the conditional formatting is not visible..how can anyone follow along ???
This is glorious, I been tryin to find out about "project management forms and templates" for a while now, and I think this has helped. Have you heard people talk about - Biycarlett Astounded Builder - (Have a quick look on google cant remember the place now ) ? It is a smashing exclusive guide for discovering how to download thousands of business and project management templates minus the hard work. Ive heard some super things about it and my mate got great results with it.
This is just superb, been searching for "how do you write a project plan document?" for a while now, and I think this has helped. Have you ever come across - Biycarlett Astounded Builder - (just google it ) ? It is a good one of a kind guide for discovering how to download thousands of business and project management templates minus the normal expense. Ive heard some interesting things about it and my neighbour got great results with it.
this is fantastic! Many thanks
In case you want to color code the bars by "Assignment", would you please suggest the respective formula? Best regards