At 8:49, I've input the correct formula, but whenever I input a percentage complete, it just fills in the whole bar, even when it's not 100. Any idea where I might've went wrong?
Hmmm...check the number formatting for the % column. Make sure that decimal values are being stored in that column and not whole numbers. The number formatting is what makes them look like percentages. Let me know if this helps or if you are still stuck.
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.
Make sure you have a semi colon " ; '' after "bar", not a comma. I had the same issue and it was because I accidently put a comma and not a semi colon.
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 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
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/
Hi. Love this, it is really helpful. However there is an issue in your End date calculation. if the start day is put down as a saturday or sunday then it takes that as the first working day rather than the following Monday so the end date is a day short. Replaceing the formula in H6 with =if(isblank(F6),"-",if(weekday(F6,2)>5,Workday(F6,G6),Workday(F6,G6-1))) fixes that issue. The conditional formatting for the light blue works fine but for the completed highlighting there is the same issue. I got past this by adding in an additional conditinal formatting with custom formula =AND(weekday($F6,2)>5,$I60,K$4>=$F6,K$4
I'm so glad that you found this helpful! And way to go on improving the formulas! Thank you for letting me know. It really helps me learn and make even better videos in the future!! 😄👍
at 18:15, when you apply the conditional formatting and the bars appear across the dates, it is not working for me. I noticed that you didn't copy and paste the formula from J6 into the rest of the blocks (or I missed that step??). Were we supposed to copy and paste the formula in J6 to the rest of the blocks? Thanks for your help!
You did not miss a step. The formula for J6 is not copies to the rest of the blocks. If you'd like, the easiest way for me to help is if you could send me a link to a copy of your spreadsheet via email. This way I can take a look at it for you. You can email me at info@spreadsheetlife.com.
followed this to the letter, however the end date formula keeps showing this error Function WORKDAY parameter 1 expects number values. But '24/06/2024' is a text and cannot be coerced to a number.
Okie dokie. Try this. Select the column containing the dates, click the more formats button (123), and select date. This should change the format to a date. See if this helps.
Double check the number formatting that is applied to your percentage column. Make sure it is set to percentage. If that doesn't fix the issue, let me know.
Nice tutorial but I have a problem, hope you can help me. When I try the "End" Formula in miunte 7:25 it appears #VALUE because its says that date is no number and cannot calculate. ¿How can I fix that?
My guess is that the date values you've entered are text and not actual dates. Be sure that you've set the number format for the date columns to Date. I hope this helps.
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 ❤
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! 😄👍
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.
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
This is the best explanation for G-Sheet Gnatt Chart on TH-cam that I have come across. Thank you! I subscribed :)
That's so amazing to hear! Thank you so much for your kind words and for subscribing! I will do my best to keep good content coming! 😊
At 8:49, I've input the correct formula, but whenever I input a percentage complete, it just fills in the whole bar, even when it's not 100. Any idea where I might've went wrong?
Hmmm...check the number formatting for the % column. Make sure that decimal values are being stored in that column and not whole numbers. The number formatting is what makes them look like percentages. Let me know if this helps or if you are still stuck.
@@spreadsheetlife Cool, thank you
😊👍
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
I found the answer, my google sheet require this line:
=IFERROR(SPARKLINE(H6;{"charttype"\"bar";"max"\1});"")
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.
Make sure you have a semi colon " ; '' after "bar", not a comma. I had the same issue and it was because I accidently put a comma and not a semi colon.
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
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.
@@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
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/
Hi. Love this, it is really helpful. However there is an issue in your End date calculation. if the start day is put down as a saturday or sunday then it takes that as the first working day rather than the following Monday so the end date is a day short. Replaceing the formula in H6 with =if(isblank(F6),"-",if(weekday(F6,2)>5,Workday(F6,G6),Workday(F6,G6-1))) fixes that issue. The conditional formatting for the light blue works fine but for the completed highlighting there is the same issue. I got past this by adding in an additional conditinal formatting with custom formula =AND(weekday($F6,2)>5,$I60,K$4>=$F6,K$4
I'm so glad that you found this helpful! And way to go on improving the formulas! Thank you for letting me know. It really helps me learn and make even better videos in the future!! 😄👍
Great simple step by step for all Gantt items. Thx!
😄😊👍
Thank you! Vey helpful.
That's so amazing to hear! Thank you for watching! 😊
at 18:15, when you apply the conditional formatting and the bars appear across the dates, it is not working for me. I noticed that you didn't copy and paste the formula from J6 into the rest of the blocks (or I missed that step??). Were we supposed to copy and paste the formula in J6 to the rest of the blocks? Thanks for your help!
You did not miss a step. The formula for J6 is not copies to the rest of the blocks. If you'd like, the easiest way for me to help is if you could send me a link to a copy of your spreadsheet via email. This way I can take a look at it for you. You can email me at info@spreadsheetlife.com.
followed this to the letter, however the end date formula keeps showing this error Function WORKDAY parameter 1 expects number values. But '24/06/2024' is a text and cannot be coerced to a number.
Okie dokie. Try this. Select the column containing the dates, click the more formats button (123), and select date. This should change the format to a date. See if this helps.
Im stuck, my progress bar stays at max even if i input 10% complete, what might be the issue, i think everything else is complete. Please help
Double check the number formatting that is applied to your percentage column. Make sure it is set to percentage. If that doesn't fix the issue, let me know.
@ Thanks for coming back to me. I purchased from your site instead. Works a treat 👏🫡
That's so awesome to hear. Thank you for the purchase, and let me know if you need any help using it. 😊👍
Nice tutorial but I have a problem, hope you can help me. When I try the "End" Formula in miunte 7:25 it appears #VALUE because its says that date is no number and cannot calculate. ¿How can I fix that?
My guess is that the date values you've entered are text and not actual dates. Be sure that you've set the number format for the date columns to Date. I hope this helps.
@@spreadsheetlife Thanks for the tip, also what it worked in my case was the "=DATEVALUE" command.
Of course! Happy to help. And thanks for letting me know. It's always fun to know how other solutions can work as well. 😄👍
Great video, thank you!! What changes would I make to the formula if I wanted to keep weekends in the calculation?
Great question. To keep the weekends, just subtract the two dates instead of using the WORKDAYS function. I hope this helps.
@@spreadsheetlife Would you mind explaining what the the formula would look like? Great video by the way!
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)
wow
😊👍
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 ❤
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! 😄👍
Hillarious full of knowldge
😅😊👍
How can I add a late column 5:I?
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.
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
How interesting. I love seeing how everyone puts their own spin on things! 😄
I'm glad you enjoyed the tutorial!