This was my first-ever viewing of Kandis. What an amazing instructor. Everything was so clearly presented and slow enough that you could follow along while setting it up. You do a GREAT job!!! Thank you, Kandis!
As a 20yr IT Technical PM, who has done close to half a billion in work for Global and Fortune 100 firms, this is an awesome video for anyone new to using smartsheets and setting up a PMO. I'm doing it for a billion dollar Biotech who's running a wild-wild west PMO and Kandis is making it super easy to get it up and running without re-inventing the wheel. Good job and thanks for putting in the time to make this.
@zodka - thank you so much for your kinds words! It really means a lot. We have worked with many clients to help them establish PMOs utilizing Smartsheet, so we bring our real-world experience to the table, along with our knowledge of the tool. We always customize the PMO setups to meet the needs of the clients, so Smartsheet’s PMO Template Set isn’t off-the-shelf, although it is fantastic to highlight the possibilities and then go from there to gather requirements. Wishing you the best on your projects - it sounds like organizations are in great hands with your expertise! Cheers, Kandis
@PMPexpert - Excellent job. I have been playing with the different project rollup templates, trying to follow instructions and it is not simple. 45 minutes with you and I have a lot set up and I understand a lot more about SmartSheet naming and asset types. Thank you!
I tried this last year, and it flew over my head. Smartsheet HAS A STEEP LEARNING CURVE. I am back! Now, her entire sequence loaded with extras goes far beyond PMO basics, beautifully outlined and detailed, and makes sense even for a solopreneur. For me, it was about customizing the organization and structure from the ground up to the executive level. (One tiny piece of advice. Take an Udemy course to the immediate and advanced level, and then this will be your next extraordinary creation.)
Thanks for coming back for a ‘round 2’, Miguel! I agree Smartsheet takes time to learn…I am still learning little things about the tool every day. Best of luck with your projects!
Brilliant tutorial. Your step by step is a state of the art and your diction allows non English speakers like me to perfectly understand and do at the same time. Thanks a lot.
I watched Part 1 of Kandis’ ‘Smartsheet Template Setup’ and found it to be extremely helpful! Not only did it answer a lot of questions I had, but I also found that Kandis is fantastic to follow and is very clear in her explanations. I’m looking forward to watching parts 2 and 3!
Dear Kandis, Thank you so much for making such an easy to understand and follow step by step video. I am new to Smartsheet and this has helped me immensely! May God bless you !
I have never put comments for a youtube video before but I have to tell you how awesome your tutorial was! I'm new at smartsheet and was so lost, I even purchased some courses on Udemy and they couldn't even walk through it like you did. Thank you so much for sharing this information! I will be watching the next 2 videos. :)
This is the best video I have seen on this subject and was really easy to follow. I am going to try and put it into practice on Monday. Really helpful and I have subscribed - thanks very much.
great content and delivery. should create an updated version to incorporate all the new upgrades. This video is still very relevant and very good and a great way to learn Smartsheet PMO set-up. well done! I'm on to Part 2........
Thanks, Chris! I’m working on a video showcasing the newer workload management features that helps project managers organize resources across multiple projects. This is one of the biggest asks we’re getting from clients currently (without having to pay for the resource management add-on module). We are excited to launch some new beginner, intermediate, and advanced Smartsheet tutorials!
Great videos, Kandis! I'm relearning Smartsheet after about an 8-year hiatus. Would you advise setting up a PMO per client or having the clients be at the project level? Each of our client projects has different components or subprojects, so I'm not quite sure what best practices would be. Thanks so much!
Hi Melissa - thanks for watching! Will your clients require access to project plans to make updates? If so, I’d consider setting up a different PMO for each of them, as access rights can only be set at the Workspace level and not at a subfolder level. If the PMO is being setup for internal management for your company, however, one PMO could work! You can also ‘Publish’ dashboards / schedules to share with your individual clients for information, without inviting them to a workspace. 😀
This is an absolutely amazing video and you did FANTASTIC at going through all the details :) I look fwd to part 2! One questions... on the intake sheet... how did you get the column headers to be labeled across row 1?
Hi Kandis, this video is very useful, thank you. We use Smartsheet at a basic level, meaning we capture the projects on the form, and all of them remain in the Intake sheet. We haven't implemented the next steps, but we want to. How can I build my PMO having as a base only my Intake sheet, which doesn't have any formula or link with other sheets?
Hello! Yes, with a Smartsheet Pro account, you can access templates. The Pro plan allows users to both create their own templates and use pre-built templates available through Smartsheet's Solution Center. Reference: Create Your Own or Use One from the Solution Center (help.smartsheet.com/articles/522123-creating-using-templates). Best of luck!
Hi Nortiz436! Is any of the information showing up as a new row after an intake form is submitted? Or is it just certain fields that aren’t populating? I’m trying to determine if it is a form link issue or other. Cheers!
Hi Kandis, finally got round to following this step by step and it was great til step 5, when not all the cells copied into the yellow cells on the project intake sheet. The Start and end dates didn't copy over. Any suggestions please?
Hello! To use the template set to its fullest, I recommend submitting the project with the intake form (which is part of the PMO template set) and then go through the steps to update it in the project plan (e.g., tasks, percent complete, predecessor tasks, assigned to, etc.). You may be able to do a simple copy/paste into the plan. This will ensure everything remains linked and you can continue to add new projects. Best of luck!
Your tutorials are awesome ! I am stuck on the project ID from the intake form not copying over into the Project Metadata , do you know the best way to solve this issue?
Hello! Congrats on the video, very clear specially for new users :) One question, is it mandatory to use the pre defined 6 questions in the Project Intake Form? For example, if i dont want to use the question "Category" can i delete it or will I impact anything else in another template contained in this set? Thank you!
Do you have other ways you categorize Projects? I would suggest using ‘Departments' or 'Areas of Focus' rather than ‘Category’ if that works better for your organization. You can delete it if you don't need it but it WILL change some of the reports that are organized by that ‘category’ column and the Portfolio Dashboard as the 'Number of projects by Status' and '# of Projects by Schedule Health' are both displayed by 'Category' column.
Thanks Kandis for this awesome material! I was following all the steps but the auto-linking part (min 35/36) doesn't work for me. I even started from scratch with a new template set but the data doesn't update automatically. From your experience, do you know what potentially went wrong here? Is there a change that something in the settings needs to be enabled?
Hello! Sure, although if you want to use the template set to it’s fullest, I would go through the steps to update it in the project plan (e.g., tasks, percent complete, predecessor tasks, assigned to, etc.) after submitted. You may be able to do a simple copy/paste if a plan is already completed. Best of luck!
Is there a way to have a workflow that will duplicate the Project template and auto populate inside the project metadata to keep it automated or will it have to still be done manually?
Thank you for the video. It's sad to see how Smarsheets doesn't really care about teaching. I'ts all about selling the software to managers who have never used excel/google sheets. : ..(
I'm sorry you haven't had a great experience with the learning side of Smartsheet! I do think it is a great tool, it just takes a bit of time to get up to speed. I hope this video helped. :)
I recently took over a project from previous employee how do I copy the plan sheet and replace the project level plan in PMO project level template and link to all other sheets within the project level templates for tracking
When starting a new project, copy the ‘Project Template’ folder located within the ‘Project Level’ folder. Paste the copied folder within the ‘Project Level’ folder and rename it to reflect your Project Name. When you copy the entire ‘Project Template’ folder for a new project all project-level sheets, reports, and dashboards are created along with the necessary links. You should not have to establish any new links. You will need to input the Project ID within the ‘Project Metadata’ sheet to have data pulled into the Project folder from the intake form.
Hi! Scroll all the way down to the bottom of your sheet and see if it is showing up there. Could there be many blank rows that got saved while you were setting it up? You have the option to have new forms populate at the top or the bottom of the sheet (this is a setting in the Forms) and I prefer to switch it to the top for this reason.
I don’t, Lily. However, maybe this (fast brainstorm) for a WBS may be helpful to organize your thoughts? I once managed an office move and stakeholder input is critical…especially when it comes to the seating arrangements (don’t underestimate how competitive people get for an office window!). Wishing you the best. 1. Project Planning 1.1 Develop a Project Plan 1.2 Define Project Scope 1.3 Develop a Project Timeline 1.4 Determine Budget 2. Moving Company 2.1 Identify and Hire a Reputable Moving Company 2.2 Obtain Quotes 2.3 Negotiate Pricing/Contract Terms 2.4 Schedule Moving Date 3. Inventory of Office Items 3.1 Create an Inventory List 3.2 Assign Labels and Tags to Items 3.3 Conduct Regular Inventory Checks 4. Team Management 4.1 Assign Roles and Responsibilities 4.2 Communicate the Move and packing dates to Employees 4.3 Provide Training if Necessary 4.4 Schedule Shifts & Absences Accordingly for packing and move 5. Communications 5.1 Develop a Communications Plan 5.2 Notify Clients, Vendors, and Suppliers of the Move 5.3 Update Company Website and Materials with New Information 5.4 Communicate Change of Address to Key Parties 6. Utility Setup 6.1 Set Up Electricity, Internet, and Phone 6.2 Request Building Access 7. New Office Setup 7.1 Develop a Floor Plan 7.2 Install Furniture and Equipment 7.3 Install Systems and Tools 7.4 Implement Storage/Organization 7.5 Create seating plan (consider your stakeholders!) 8. Cleanup 8.1 Conduct Cleanup at Existing Location 8.2 Dispose of Unwanted Items 8.3 Donate Unneeded Items 9. Employee Support 9.1 Prepare for Employee Assistance 9.2 Coordinate Move-In 9.3 Address Facilitation and Needs 9.4 Issue building access badges 10. Evaluation 10.1 Evaluate Success & Lessons Learned 10.2 Identify area for improvements
Hi @kandis can you help how to put the project id in project metadata, so automatically other details will reflect. Mine is not working, I am tried lot of times with correct ans same to you, but it didnt work
Smartsheet PMO Template Setup - Part 1 - Setup & Customize: th-cam.com/video/EEzigqZjLlA/w-d-xo.html
Smartsheet PMO Template Setup - Part 2 - Customize Project Intake and Portfolio Level: th-cam.com/video/OW9mLhOwVLE/w-d-xo.html
This was my first-ever viewing of Kandis. What an amazing instructor. Everything was so clearly presented and slow enough that you could follow along while setting it up. You do a GREAT job!!! Thank you, Kandis!
Thank you, Cathy! Wishing you the best with the PMO set. :)
As a 20yr IT Technical PM, who has done close to half a billion in work for Global and Fortune 100 firms, this is an awesome video for anyone new to using smartsheets and setting up a PMO. I'm doing it for a billion dollar Biotech who's running a wild-wild west PMO and Kandis is making it super easy to get it up and running without re-inventing the wheel. Good job and thanks for putting in the time to make this.
@zodka - thank you so much for your kinds words! It really means a lot.
We have worked with many clients to help them establish PMOs utilizing Smartsheet, so we bring our real-world experience to the table, along with our knowledge of the tool. We always customize the PMO setups to meet the needs of the clients, so Smartsheet’s PMO Template Set isn’t off-the-shelf, although it is fantastic to highlight the possibilities and then go from there to gather requirements.
Wishing you the best on your projects - it sounds like organizations are in great hands with your expertise!
Cheers, Kandis
@PMPexpert - Excellent job. I have been playing with the different project rollup templates, trying to follow instructions and it is not simple. 45 minutes with you and I have a lot set up and I understand a lot more about SmartSheet naming and asset types. Thank you!
So happy this video was helpful, John! Wishing you the best on your projects. 🙌🏻
I tried this last year, and it flew over my head. Smartsheet HAS A STEEP LEARNING CURVE. I am back! Now, her entire sequence loaded with extras goes far beyond PMO basics, beautifully outlined and detailed, and makes sense even for a solopreneur. For me, it was about customizing the organization and structure from the ground up to the executive level. (One tiny piece of advice. Take an Udemy course to the immediate and advanced level, and then this will be your next extraordinary creation.)
Thanks for coming back for a ‘round 2’, Miguel! I agree Smartsheet takes time to learn…I am still learning little things about the tool every day. Best of luck with your projects!
Brilliant tutorial. Your step by step is a state of the art and your diction allows non English speakers like me to perfectly understand and do at the same time. Thanks a lot.
Thank you!
I watched Part 1 of Kandis’ ‘Smartsheet Template Setup’ and found it to be extremely helpful! Not only did it answer a lot of questions I had, but I also found that Kandis is fantastic to follow and is very clear in her explanations. I’m looking forward to watching parts 2 and 3!
Glad it was helpful!
You are a ROCK STAR Kandis. Thank you for doing these videos. Very helpful!
Thank you for watching! 🙏🏻
Dear Kandis, Thank you so much for making such an easy to understand and follow step by step video. I am new to Smartsheet and this has helped me immensely! May God bless you !
Thanks for watching! I’m so happy to hear it’s helpful. New videos on Smartsheet are coming soon.
I have never put comments for a youtube video before but I have to tell you how awesome your tutorial was! I'm new at smartsheet and was so lost, I even purchased some courses on Udemy and they couldn't even walk through it like you did. Thank you so much for sharing this information! I will be watching the next 2 videos. :)
Thank you! I feel honored to be your first YT comment. Wishing you best of luck on your projects. :)
same here
Excellent instruction Kandis! Clear. Well-paced. Easy to follow and understand. Awesome job!
Thank you, John! Much appreciated feedback. Wishing you the best and thanks for watching. 🙌🏻
This is the best video I have seen on this subject and was really easy to follow. I am going to try and put it into practice on Monday. Really helpful and I have subscribed - thanks very much.
Awesome, thanks for watching, Steve! Best of luck putting it into practice. 🙌🏻
Seriously this is the best Smartsheet video I have ever seen. Your presentation, flow and speed are all wonderful. New subscriber here
You’re so kind! Thanks, Daniel. Welcome to the channel!
This is AWESOME!
Thanks for watching, PattiS!
great content and delivery. should create an updated version to incorporate all the new upgrades. This video is still very relevant and very good and a great way to learn Smartsheet PMO set-up. well done! I'm on to Part 2........
Thanks, Chris! I’m working on a video showcasing the newer workload management features that helps project managers organize resources across multiple projects. This is one of the biggest asks we’re getting from clients currently (without having to pay for the resource management add-on module). We are excited to launch some new beginner, intermediate, and advanced Smartsheet tutorials!
@@PMPexpert looking forward to viewing
Thank you , Kandis. I am following your step by step instructions and it works for me, including your feedback
Fantastic! Thanks for the feedback, Madeline!
You are welcome
Great videos, Kandis! I'm relearning Smartsheet after about an 8-year hiatus. Would you advise setting up a PMO per client or having the clients be at the project level? Each of our client projects has different components or subprojects, so I'm not quite sure what best practices would be. Thanks so much!
Hi Melissa - thanks for watching! Will your clients require access to project plans to make updates? If so, I’d consider setting up a different PMO for each of them, as access rights can only be set at the Workspace level and not at a subfolder level.
If the PMO is being setup for internal management for your company, however, one PMO could work! You can also ‘Publish’ dashboards / schedules to share with your individual clients for information, without inviting them to a workspace. 😀
@@PMPexpert Thank you so much! Yes, some will access it to add notes and status updates to project plans, etc., so this is very helpful. 🙂
Very good, thanks!!
Thanks, Edgar! Best wishes on your projects. 🙌🏻
This is an absolutely amazing video and you did FANTASTIC at going through all the details :) I look fwd to part 2! One questions... on the intake sheet... how did you get the column headers to be labeled across row 1?
Great instructions Kandis!
Thanks so much!
You're vids are just amazing! thanks for sharing!!!
Glad you like them! Thanks for watching.
Hi Kandis, this video is very useful, thank you. We use Smartsheet at a basic level, meaning we capture the projects on the form, and all of them remain in the Intake sheet. We haven't implemented the next steps, but we want to. How can I build my PMO having as a base only my Intake sheet, which doesn't have any formula or link with other sheets?
Great material, Kandis. Thank you for sharing!
Thanks, Paul! I hope you found it helpful. I tried to boil it down into simple steps. Thanks for watching!
@@PMPexpert You did a great job of breaking each area down to simple steps. Perfect pace, content, delivery, and messaging!
Best turotiol so far!
Thank you, Stallion!
Hello kandis! First, thank you for the brilliant explanation. Do you know if this template works in the Pro Version? Or just in the business version?
Hello! Yes, with a Smartsheet Pro account, you can access templates. The Pro plan allows users to both create their own templates and use pre-built templates available through Smartsheet's Solution Center.
Reference: Create Your Own or Use One from the Solution Center (help.smartsheet.com/articles/522123-creating-using-templates). Best of luck!
Thank you so much for this series explaining in detail. Very helpful
You're very welcome!
Loved the video! QQ- When updating the metadata, what do you do when it doesn't populate from the intake form? 😢
Hi Nortiz436! Is any of the information showing up as a new row after an intake form is submitted? Or is it just certain fields that aren’t populating? I’m trying to determine if it is a form link issue or other. Cheers!
fantastic - so helpful!
God bless you!
Thank you!
Kandi your videos are amazing! Thank you ❤
Glad you like them! Thanks, Queen Yogi!
Hi Kandis, finally got round to following this step by step and it was great til step 5, when not all the cells copied into the yellow cells on the project intake sheet. The Start and end dates didn't copy over. Any suggestions please?
Hi @Kandis it was a useful, what if I started my project with the regular template and don't have the metadata template? How can I get the Project ID?
Hello! To use the template set to its fullest, I recommend submitting the project with the intake form (which is part of the PMO template set) and then go through the steps to update it in the project plan (e.g., tasks, percent complete, predecessor tasks, assigned to, etc.). You may be able to do a simple copy/paste into the plan. This will ensure everything remains linked and you can continue to add new projects. Best of luck!
Your tutorials are awesome ! I am stuck on the project ID from the intake form not copying over into the Project Metadata , do you know the best way to solve this issue?
Hello! Congrats on the video, very clear specially for new users :) One question, is it mandatory to use the pre defined 6 questions in the Project Intake Form? For example, if i dont want to use the question "Category" can i delete it or will I impact anything else in another template contained in this set? Thank you!
Do you have other ways you categorize Projects? I would suggest using ‘Departments' or 'Areas of Focus' rather than ‘Category’ if that works better for your organization. You can delete it if you don't need it but it WILL change some of the reports that are organized by that ‘category’ column and the Portfolio Dashboard as the 'Number of projects by Status' and '# of Projects by Schedule Health' are both displayed by 'Category' column.
I made a number of changes to the project folder and want to save that as my new template - do you recommend doing that?
Hello Sherry! Yes, as long as everything is properly linked to the PMO set, I highly encourage teams to tailor to their needs. Great work!
Thanks Kandis for this awesome material! I was following all the steps but the auto-linking part (min 35/36) doesn't work for me. I even started from scratch with a new template set but the data doesn't update automatically. From your experience, do you know what potentially went wrong here? Is there a change that something in the settings needs to be enabled?
Same for me, Let me know If you are now able to edit or set up new project id in project metadata.
Hey Kandis, is it possible for an already existing project to be submitted through the Project Intake Form?
Hello! Sure, although if you want to use the template set to it’s fullest, I would go through the steps to update it in the project plan (e.g., tasks, percent complete, predecessor tasks, assigned to, etc.) after submitted. You may be able to do a simple copy/paste if a plan is already completed. Best of luck!
Is there a way to have a workflow that will duplicate the Project template and auto populate inside the project metadata to keep it automated or will it have to still be done manually?
Thank you for the video. It's sad to see how Smarsheets doesn't really care about teaching. I'ts all about selling the software to managers who have never used excel/google sheets. : ..(
I'm sorry you haven't had a great experience with the learning side of Smartsheet! I do think it is a great tool, it just takes a bit of time to get up to speed. I hope this video helped. :)
They have a great free learning track for new users (:
I recently took over a project from previous employee how do I copy the plan sheet and replace the project level plan in PMO project level template and link to all other sheets within the project level templates for tracking
When starting a new project, copy the ‘Project Template’ folder located within the ‘Project Level’ folder. Paste the copied folder within the ‘Project Level’ folder and rename it to reflect your Project Name. When you copy the entire ‘Project Template’ folder for a new project all project-level sheets, reports, and dashboards are created along with the necessary links. You should not have to establish any new links. You will need to input the Project ID within the ‘Project Metadata’ sheet to have data pulled into the Project folder from the intake form.
My Project ID isn't auto-populating in my intake sheet after I submit the intake form. I am not sure how to troubleshoot this? Any advice?
Hi! Scroll all the way down to the bottom of your sheet and see if it is showing up there. Could there be many blank rows that got saved while you were setting it up? You have the option to have new forms populate at the top or the bottom of the sheet (this is a setting in the Forms) and I prefer to switch it to the top for this reason.
Do you have a project management deck for an office move?
I don’t, Lily. However, maybe this (fast brainstorm) for a WBS may be helpful to organize your thoughts? I once managed an office move and stakeholder input is critical…especially when it comes to the seating arrangements (don’t underestimate how competitive people get for an office window!). Wishing you the best.
1. Project Planning
1.1 Develop a Project Plan
1.2 Define Project Scope
1.3 Develop a Project Timeline
1.4 Determine Budget
2. Moving Company
2.1 Identify and Hire a Reputable Moving Company
2.2 Obtain Quotes
2.3 Negotiate Pricing/Contract Terms
2.4 Schedule Moving Date
3. Inventory of Office Items
3.1 Create an Inventory List
3.2 Assign Labels and Tags to Items
3.3 Conduct Regular Inventory Checks
4. Team Management
4.1 Assign Roles and Responsibilities
4.2 Communicate the Move and packing dates to Employees
4.3 Provide Training if Necessary
4.4 Schedule Shifts & Absences Accordingly for packing and move
5. Communications
5.1 Develop a Communications Plan
5.2 Notify Clients, Vendors, and Suppliers of the Move
5.3 Update Company Website and Materials with New Information
5.4 Communicate Change of Address to Key Parties
6. Utility Setup
6.1 Set Up Electricity, Internet, and Phone
6.2 Request Building Access
7. New Office Setup
7.1 Develop a Floor Plan
7.2 Install Furniture and Equipment
7.3 Install Systems and Tools
7.4 Implement Storage/Organization
7.5 Create seating plan (consider your stakeholders!)
8. Cleanup
8.1 Conduct Cleanup at Existing Location
8.2 Dispose of Unwanted Items
8.3 Donate Unneeded Items
9. Employee Support
9.1 Prepare for Employee Assistance
9.2 Coordinate Move-In
9.3 Address Facilitation and Needs
9.4 Issue building access badges
10. Evaluation
10.1 Evaluate Success & Lessons Learned
10.2 Identify area for improvements
Hi @kandis can you help how to put the project id in project metadata, so automatically other details will reflect. Mine is not working, I am tried lot of times with correct ans same to you, but it didnt work
At 29:50 in Row 1 under the new "PM Timezone" heading, the field is empty. Will that present an issue later? (the other fields on Row 1 have titles)
Anybody have any thoughts on this?
I love your videos. How can I contact you via email to ask for recommendations on setup.
Thanks for watching! You can email us at inquiry@effectiveflowconnections.com. Wishing you the best on your projects.
@@PMPexpert email message sent. Thanks
Smartsheet PMO Template Setup - Part 1 - Setup & Customize: th-cam.com/video/EEzigqZjLlA/w-d-xo.html
Smartsheet PMO Template Setup - Part 2 - Customize Project Intake and Portfolio Level: th-cam.com/video/OW9mLhOwVLE/w-d-xo.html