Smartsheet Gantt Chart Tutorial [Smartsheet Training]
Vložit
- čas přidán 30. 06. 2024
- Learn how to set up and manage a Gantt Chart in Smartsheet from scratch. We cover all the functionality you need to use and consider to help you track and manage your project.
🚀 Master Smartsheet with my training courses 👉properprojectmanagement.com/s...
👇 HOW I CAN HELP YOU 👇
--------------------------------------------
🗣️ Project Management Consultations:
properprojectmanagement.com/c...
📈 Project Management Solution Design, Build & Support:
properprojectmanagement.com/p...
📄 Project Management Templates:
properprojectmanagement.com/p...
🚀 General Business Inquiries/Sponsorships:
properprojectmanagement.com/b...
🚀 Master Smartsheet functionality in half the time 👉 properprojectmanagementtraining.teachable.com/p/smartsheet-fundamentals
Stuctured and easy to follow with all what is needed to get Gantt charts in Smartsheets..Thanks
Good to hear it, thanks for your kind words Deia
A great video and thanks for sharing these tips and knowledge!
Thank you - glad it was helpful!
Smartsheet template for Gantt chart is a great starting point and your video was very helpful. However, I could use a detail explanation of creating lines and parent-child relationships. Also, copying sections, which I assume is possible. Thank you!
Thanks David; good idea, will look into this!
Great video, very helpful.
I am new to SS and building a project to remodel my offices. I don’t understand how the project moves forward by percentage. I have my start / end dates, durations % complete, team members assigned etc…
I still have some building left but stuck here.
Thank you
Thanks, Stuart! Regarding the percentage - what do you want to know? Sounds like you have all of the other required data though.
@@ProperProjectManagement I don't know how the assigned people connected to the task move it forward for example. How do they move the progress forward or complete a task?
I don't expect the entire answer here of course but do you recommend other quick start guides to newbies? I am building from som SS templates (super helpful). Thanks again...
perfect and well explained
Thank you
It would be great to have a tutorial from start to finish.
Hi Donny. Thanks for the feedback. Will have a look into recording this!
Thank you for the very useful demo. I want to get an excel sheet export of my Gantt chart but using the file/export... it does not export the Gantt part, only the columns. Is a way around this?
Glad it was helpful! Unfortunately, there is not a way of doing this.
Hi thanks for the video. Is it possible to have recurring tasks on a line? To represent a quarterly meeting for example
Yes, absolutely. I believe this is what you are looking for: community.smartsheet.com/discussion/74769/project-management-how-do-i-create-a-recurring-task-within-a-project-task-list
Great video! How do you add the text to appear at the end of each task? I am currently create a programme but the text is not showing. Thank you.
Hi. Please refer to: community.smartsheet.com/discussion/460/how-to-make-task-name-visable-in-gantt-chart Thanks
Greetings, It is possible to add conditional formatting to the Gantt Chart bars? They are all black as of now and it would be cool if they changed color based on another criteria.
For example, if it is placed on hold, the bar changes yellow.
Hello Marc, that would be great. Not sure if it's currently possible, though. Perhaps reach out to Smartsheet on this or even raise as an enhancement
Great Video, very helpful. When I try to export the Gantt chart from Smartsheet to Excel - I am unable to see the Gantt chart in excel. Any tips?
Hello Jas; thank you. I would actually contact Smartsheet support on this one. They may be able to provide you with greater insight based on your requirements.
Hi
This was very helpful! Do you know how to add new tasks? I noticed when you started you had already had all the tasks add on to your Gantt
Sure, right click on one of the rows on the left hand side of the sheet and click "insert above" or "insert below" depending on what you need.
HI, i am working on one project where we keep adding the additional task month-wise so baseline of the project keeps changing for the entire process. how do I fix the baseline for old task?
Hi Chirag, this article may be of help: help.smartsheet.com/articles/2482093-baselines
Can you see a whole of project Gantt chart in Smartsheet even if your project is months or years in duration? Like the 'print preview' view & condensing it all to one page?
Yes, I believe you can. you may need to scroll/adjust your views accordingly, but it should be possible.
Hi, What happens if I have one task for the first half of the day and another task for the second half? Can I set hours inside the specific day?
(For example: 08:00-12:00 and 12:00-17:00 on the same day)
Hello Dan. I believe it is possible to have tasks with a duration of hours, instead of days. You'll need to add the number of hours in each task e.g "3h" (3 hours) in the duration column instead of just a number. Here's a post in the community that may be of use: community.smartsheet.com/discussion/37256/duration-by-hours
@@ProperProjectManagement Thanks!
how can i include ahead/behind schedule in the progress numbers. to be more clear, when i say an activity had 30% progress, it does need to show what was the expected progress. in this example, whether the expected progress was 50% and we made 30%, or the expected progress was 20% and we made 30%. i need to show this in my numbers
Sounds like you would need a custom if statement formula. help.smartsheet.com/function/if
How do we add these RGB color Dots in status column?
Hello Anzar. You want to change the column properties. So right click on the column, click the bottom link "edit column properties". From there click "symbols" and then look for the RGB color dots in RAG
How can I add formulated columns into the ghantt chart.When I add the percentage complete column that has a forumla to it,the smartsheet automatically removes the formula from the cell.
I believe this is a limitation, unfortunately. There are many community posts referencing similar examples, e.g.: community.smartsheet.com/discussion/82448/why-cant-gantt-charts-have-a-formula-in-the-start-end-date-columns
How can project phases can be visible in Gantt view of portfolio...?
I would suggest you set up a parent/child relationship where phases are the parent. This should then display in the Gantt accordingly.