Spreadsheets are awesome and we want to help everybody learn how to use them. Vertex42 has been creating and providing professional spreadsheet templates since 2003. Our RU-vid channel provides demos and tutorials to help you use the templates. We are also creating tutorials to help you use both Excel and Google Sheets better.
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!
thank you for your wonderful tutorial. Excellent and I really love it!!! Just 1 question: when the duration is plus 0.5, how do you calculate the right end date?
How to exclude saturday and sunday in the bar? For example, if the duration is 6 then the result is 1 week plus 1 day because it excludes the sat and sun.
Great work. However I cannot get the formula for progress bar to work. All I get displayed is "0". No "1". Not even changing the numbers in the progress bar does the trick.
hello, I want to give colour type of task, For example , Design = "D" and I want to my code, check it "D" for all dates and bar color is black for all D types. How can I do it ?
There are not enough categories... I need all the categories from version 1 to be added to version 2. Please give me step by step instructions to "Unhide the hidden rows in the Budget and Report worksheets if you need more categories" I need to add the 50 hidden rows to do so, please help. Thanks
Thanks for this tutorial - really great. The text with tasks e.g. Task 1.1 in the bar chart is not using the indenting of row A - any ideas? the text is just aligned to the y-axis. This cannot be seen in your example because all tasks have the same name length
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 video is incredible, THANK YOU. One question if anyone is still reading this thread: how can I add a 3rd and 4th phase or additional tasks within a phase without screwing up the formulas and formatting? Assuming there’s a way but I’m a total newbie to Sheets and can’t figure it out. Any help hugely appreciated, thank you!
Hi guys, I applied the formula to make the timeline dynamic, however it doesn´t work well, when I change the display week only change the row with dates but not the complete data . Do you know what´s going on?
I need a help for my formula, I want color my column using conditional formating but exclude sunday and national holidays without reducing the number of working days, can you give me the right formula, please?