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!
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?
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
@@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...
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 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
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.
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
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, 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
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
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
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?
🚀 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
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!
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!
A great video and thanks for sharing these tips and knowledge!
Thank you - glad it was helpful!
Is it possible to baseline Smartsheet gantt charts and show live tasks on the same sheet?
perfect and well explained
Thank you
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.
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...
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
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
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.
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
You can't use the gantt until the dates are in so how do you set up the start and end dates?
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
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
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 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
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.
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.