Really great Tutorial. I am new to Smartsheet I learnt a ton of new strategies which I am going to apply on my projects. I enjoyed the pace and clarity of the tutorial. Well done
Very well done. I was sort of lost. The few things you showed helps me understand how Smartsheet 'thinks' which will hopefully help me figure out how to do other things as well as when I am stuck how to look for an answer to a question. Thank You!
Great video, thank you! - I like the idea of the project intake sheet. do you have more videos on that one? in particular i'm trying to understand how to link the percentage complete and duration to the project sheet. I can see how to link a field like finish date - since that is a field in my sub project list, but if i'm trying to add a summary or calculated field like you have there like percentage complete where does that calculation take place and how to link it to the intake sheet field? thanks!
Have you checked out our Smartsheet Playlist? th-cam.com/play/PLO3D1ido-Qg6eBqKtnAtWk3iJS_-mpyiX.html&si=clZ5KAdZZceIFlFk I think our PMO Solution video or our Project Dashboard video may help. ALSO - we have a live webinar coming up on Product data - and I think it will cover this in dept. You can register : www.echoprojectmanagement.com/event-details-registration/leveraging-data-for-project-management
Thank you very much for sharing these information! 🙂 But how can I add functionality to this to have an overview of all employees involved and what tasks have been assigned to them; to be able to do a resources planning?
Great question! There are many different methods to address resource planning in Smartsheet. If you're simply looking for what tasks are assigned to every team member across multiple projects, you can take advantage of Smartsheet reports for this. For example, you can create a report that has a source of all project plans you'd like included, add the relevant columns and group by 'Assigned To' or whatever the name of the column is for who is responsible for the task. You an add a summary as well. This method simply gets you a count of their tasks. Smartsheet also offers a resource planning tool, called Resource Management. This is a robust software that allows you to forecast future work as well as keep track of active work and see each team members' % capacity. You can learn more about the Resource Management tool here: www.smartsheet.com/platform/resource-management The last option I'll suggest is to have a separate resourcing sheet that includes rows for projects and team members with columns for each month (or quarter) in the year and input the % allocation you expect the team member to be allocated to each project they are working on. This sheet can then be pulled into reports to use the summary option and see who is over 100% allocation. This last option is a bit trickier to explain in a comment, but this is great feedback for our team and we will work to do a video tutorial on this question soon!
Yes - it depends on your scenario : There are templates in Smartsheet, but it won't update sheets created from the template if you need to change a column name or type, so we typically just advise our clients to "Save as New" from a "Template" folder....... unless they have more than 30+ projects ongoing at a time, and then we consider whether we need Control Center (Smartsheet Add-On that costs more money), OR we need to consolidate project plans..... Again, depends on the need.
did you use a specific template for this or did you manually created most of the columns? for instance: problem to solve/opportunity, proposed solution, etc. i wonder if there's a template that has most of those columns already
Great question, and often this comes down to personal preference and project complexity. We find that having different sheets for different projects is the most helpful. We can use one sheet to track all the project parameters, and know that that sheet is the command center for the project. But if the projects are more simple to manage, it's definitely possible to have more than one on a sheet. It just depends on your preference and project workload.
Really great Tutorial. I am new to Smartsheet I learnt a ton of new strategies which I am going to apply on my projects. I enjoyed the pace and clarity of the tutorial. Well done
We are so glad you found it helpful! - We release new videos every week! Please subscribe, and you will notified of new content!
Very well done. I was sort of lost. The few things you showed helps me understand how Smartsheet 'thinks' which will hopefully help me figure out how to do other things as well as when I am stuck how to look for an answer to a question. Thank You!
Glad you liked it! - You are not alone - many get lost at first, but there is a great community and templates to help get you situated! Baby steps!
Great video, thank you! - I like the idea of the project intake sheet. do you have more videos on that one? in particular i'm trying to understand how to link the percentage complete and duration to the project sheet. I can see how to link a field like finish date - since that is a field in my sub project list, but if i'm trying to add a summary or calculated field like you have there like percentage complete where does that calculation take place and how to link it to the intake sheet field? thanks!
Have you checked out our Smartsheet Playlist? th-cam.com/play/PLO3D1ido-Qg6eBqKtnAtWk3iJS_-mpyiX.html&si=clZ5KAdZZceIFlFk
I think our PMO Solution video or our Project Dashboard video may help.
ALSO - we have a live webinar coming up on Product data - and I think it will cover this in dept. You can register : www.echoprojectmanagement.com/event-details-registration/leveraging-data-for-project-management
Great video and good examples, thanks!
Happy to help! Glad you enjoyed it!
Great great great information. Thank you
Yay! Glad you liked it! Did you know you can subscribe to our channel and get notified when new videos drop?
Thank you very much for sharing these information! 🙂 But how can I add functionality to this to have an overview of all employees involved and what tasks have been assigned to them; to be able to do a resources planning?
Great question! There are many different methods to address resource planning in Smartsheet. If you're simply looking for what tasks are assigned to every team member across multiple projects, you can take advantage of Smartsheet reports for this. For example, you can create a report that has a source of all project plans you'd like included, add the relevant columns and group by 'Assigned To' or whatever the name of the column is for who is responsible for the task. You an add a summary as well. This method simply gets you a count of their tasks.
Smartsheet also offers a resource planning tool, called Resource Management. This is a robust software that allows you to forecast future work as well as keep track of active work and see each team members' % capacity. You can learn more about the Resource Management tool here: www.smartsheet.com/platform/resource-management
The last option I'll suggest is to have a separate resourcing sheet that includes rows for projects and team members with columns for each month (or quarter) in the year and input the % allocation you expect the team member to be allocated to each project they are working on. This sheet can then be pulled into reports to use the summary option and see who is over 100% allocation.
This last option is a bit trickier to explain in a comment, but this is great feedback for our team and we will work to do a video tutorial on this question soon!
@@echolocity Thank yoiu so much for responding so quickly. Great answer! 😀 It really helps me and I appreciate it a lot! Thank you! 🙂
Around 7:00 you discuss using a standard sheet. Can you create a template that all projects can start with?
Yes - it depends on your scenario : There are templates in Smartsheet, but it won't update sheets created from the template if you need to change a column name or type, so we typically just advise our clients to "Save as New" from a "Template" folder....... unless they have more than 30+ projects ongoing at a time, and then we consider whether we need Control Center (Smartsheet Add-On that costs more money), OR we need to consolidate project plans.....
Again, depends on the need.
did you use a specific template for this or did you manually created most of the columns? for instance: problem to solve/opportunity, proposed solution, etc. i wonder if there's a template that has most of those columns already
Hi @cataytimo - all of the templates/sheets in the video were created by our team. Let us know if there is anything else you need help with.
Is it best to have one project with multiple task per sheet or can you manage multiple projects from one sheet with the same repeating tasks?
Great question, and often this comes down to personal preference and project complexity. We find that having different sheets for different projects is the most helpful. We can use one sheet to track all the project parameters, and know that that sheet is the command center for the project. But if the projects are more simple to manage, it's definitely possible to have more than one on a sheet. It just depends on your preference and project workload.