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.
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! 😄👍
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.
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/
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.
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
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.
Great simple step by step for all Gantt items. Thx!
😄😊👍
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)
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.
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! 😄👍
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.
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/
Hillarious full of knowldge
😅😊👍
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. 😄👍
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!
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.