Very helpful. I've never used Google Sheets, but I have used Excel. I watched three other how-to videos on Google Sheets and found myself overwhelmed by the information. Your video/this video is the first one that I have found to be clear, concise, and easy to understand. Thank you.
Thank you for your informative presentation. It is very similar to my project management template structure. I add Conditional Formatting to my Status column, where: "Not Started" is Pink, "In Progress" is Yellow, "Complete" is Light Green, and "On Hold" is Medium Purple with Yellow text. The color formatting allows a quick assessment of the project task Status.
Hi Jeremy. I began creating my sheet and arrived to about 14:20 and got stuck. I see now that this video is two years old, which might explain why our screens are different. When adding the data validation, your guidance does not match up to mine and I can't move forward until I understand it. Any advice?
Hi, Jeremy! Nice video. Helpful! I would like to ask you: could you please provide a more detail video about WBS? I mean a detail explanations using real or fake project: what to do in "Communication plan"? What is the difference between Monitoring (3.2.1) and Project Management & Monitoring (4) ? What to monitor in each? What are (or could be) quality deliverables? What is Effort in the sense of PM (what to track)? Thanks!
![How to Create an Excel Action Plan for Your Project [EASY + EFFECTIVE]](/img/n.gif)
🚀Get my project management templates 👉 properprojectmanagement.com/project-management-templates/
Well, I can say without a shadow of a doubt that you, my friend, have become my online lecture from now on. Understood everything ❤🎉🎉Thanks
Wow, thank you for the kind words. You're welcome!
Very helpful. I've never used Google Sheets, but I have used Excel. I watched three other how-to videos on Google Sheets and found myself overwhelmed by the information. Your video/this video is the first one that I have found to be clear, concise, and easy to understand. Thank you.
Delighted to hear, thanks for sharing!
Thank you for your informative presentation. It is very similar to my project management template structure. I add Conditional Formatting to my Status column, where: "Not Started" is Pink, "In Progress" is Yellow, "Complete" is Light Green, and "On Hold" is Medium Purple with Yellow text. The color formatting allows a quick assessment of the project task Status.
Great ideas Gene, thanks for sharing!
This was very useful!!! Thank You!! I followed step by step
Glad it helped! Thanks Ariel
Thank you for the wonderful presentation. Easy to understand and implement!
You're very welcome! Thanks for the kind words and glad it helped!
Thank you, Jeremy! Very helpful and well made video.
Glad it was helpful! Thanks for dropping a comment
Highly, highly helpful! Thanks so much!
You're so welcome!
This was really helpful. Thank you so much!
You're so welcome!
Really thorough and helpful, thank you!
Glad it was helpful! You're very welcome Nick!
Hi Jeremy. I began creating my sheet and arrived to about 14:20 and got stuck. I see now that this video is two years old, which might explain why our screens are different. When adding the data validation, your guidance does not match up to mine and I can't move forward until I understand it. Any advice?
Hi again. Ignore my question as I went to Google help to learn it. I performed the steps you suggested backward 🙄thank you for a great lesson!
Glad to hear you got it sorted!
@@ProperProjectManagement thanks again for helping us move along with our projects.
This is great man. Thanks
Glad it helped!
Hi, Jeremy!
Nice video. Helpful!
I would like to ask you: could you please provide a more detail video about WBS?
I mean a detail explanations using real or fake project: what to do in "Communication plan"? What is the difference between Monitoring (3.2.1) and Project Management & Monitoring (4) ? What to monitor in each? What are (or could be) quality deliverables? What is Effort in the sense of PM (what to track)?
Thanks!
Noted! Will add this to my record list. Thanks Demyan!
Thank you !!!! Subscribed
You're very welcome!
Do you have a link to for creating charts from this data etc?
Not at the moment but something I will explore in future videos for sure!
How do I include costing in this template?
Hello Millie. What kind of costing are you looking to track?
Thank you for your reply, wages and purchase of materials for a campaign
How do you calculate percentage complete for a project task in google sheets
You would need to set up a formula and then formatting to apply the percentage view. Do you have cell references so that I can help further?
Thank you, but I don't know why these formulas are not working for me
Have you double checked they are exactly the same?
@@ProperProjectManagement Yes, sure I checked several times
Bro why 28/06/2022 change to 07/06/2022 . Idont understand
At what point in the video are you referring to?