What is a Gantt chart?<\/h5>\n
A Gantt chart is a visual representation of start dates, end dates, and progress shown as a horizontal bar chart. It is a made up of columns and rows. The rows represent the list of tasks or important components. The columns represent the time scale or segments. ProjectSheet utilizes the Gantt method with Work Breakdown Structure (WBS).<\/p>\n
WBS is another project management concept that helps look at your project from a big picture standpoint and break it into detailed, actionable items. Use WBS to assign a hierarchy to the work that needs to be completed or delivered by your team. Then, the Gantt serves to give everyone a detailed understanding of both the big picture and everyone\u2019s individual working part in the completion of the project.<\/p>\n
How to access the ProjectSheet planning add-on<\/h4>\n
It is really simple to get add-ons for Sheets! The fastest way to get ProjectSheet planning is to\u00a0<\/span>click this link<\/a>\u00a0that will take you directly to the\u00a0web store. Simply click the\u00a0Free<\/strong>\u00a0<\/span>button and the add-on will be added to your Google Sheets account.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/projectsheet-1.png” alt=”projectsheet 1″ title_text=”projectsheet 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Alternatively, you can get the add-on by following these steps:<\/p>\n 1. Open a spreadsheet To run the add-on, open a Sheet, and click\u00a0Add-ons\u00a0<\/strong>\u2192\u00a0ProjectSheet planning\u00a0<\/strong>\u2192\u00a0Add ProjectSheet<\/strong><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/projectsheet-2.png” alt=”projectsheet 2″ title_text=”projectsheet 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The add-on will work for a few minutes to set up your spreadsheets and load the sidebar. An announcement about the Pro version of ProjectSheet planning will load, go ahead and\u00a0close the dialogue box for now. At first glance, we can see that the add-on has created two new tabs named\u00a0<\/span>Project Summary<\/strong>\u00a0<\/span>and\u00a0<\/span>Task Schedule.\u00a0<\/strong>You can take a look at these sheets by clicking the tabs on the bottom left side of the sheet.<\/p>\n Task Schedule:\u00a0<\/strong>The task schedule sheet is the Grannt\u00a0Chart mentioned earlier in the article. Each column represents an important piece of information about the tasks that make up your project plan, such as, Work Breakdown Structure (WBS) rank, task description, start\/end date, progress, and a weekly\/monthly calendar. This tab is going to the spreadsheet that you interact with to track your project progress.<\/p>\n Sidebar:\u00a0<\/strong>Use the sidebar to customize your task schedule settings. You can change things like how you view tasks, the start date of tasks, and your timescale.<\/p>\n Project Summary:\u00a0<\/strong>This tab is a read-only\u00a0spreadsheet. It pulls your\u00a0project information from the Task Schedule tab, to provide an overview summary of your project. It is not editable and has a lot more information available in the report if you subscribe to the Pro version. The free version only displays the start and end date of tasks, and the percentage\u00a0of completion for each task, even without the Pro features it is still a valuable visual aid.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/projectsheet-3.png” alt=”projectsheet 3″ title_text=”projectsheet 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Next, we can input some tasks into our Task Schedule and try a few different ways of manipulating them. Depending on your project management experience, this process could be a breeze, or there could be a bit of a learning curve. If you are unfamiliar with Gantt charts or\u00a0<\/span>WBS<\/a>, you may want to check out a\u00a0more detailed\u00a0<\/span>tutorial<\/a>\u00a0<\/span>that explains how to implement these concepts in your project planning process.<\/p>\n Although this template is somewhat flexible, you need to be sure to follow some of the guidelines laid out by the designers, or you might mess up your sheets and have to start again. Make sure you only adjust the time scale using the sidebar and add any custom headers or columns into the left of the Gantt\u00a0chart. In addition, if you share the spreadsheet with your team, be sure to only share it as \u201cView only\u201d. If someone else gets in there and starts changing things, you might have to recreate the whole spreadsheet! Do not attempt to copy and paste content or other spreadsheets into ProjectSheet or delete columns or headers. You also cannot use custom formulas in this spreadsheet. This template is highly functional, but be sure to use it within the parameters of the design, or you may experience some frustration!<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" ProjectSheet planning is a template made by\u00a0forScale, a company that creates easy-to-use, effective technology for project management. ProjectSheet planning is an add-on for Google Sheets\u2014use it to supercharge the way you track tasks and help you stay on track to ensure you are meeting deadlines and hitting milestones. Use the ProjectSheet planning add-on as an […]<\/p>\n","protected":false},"author":40,"featured_media":44271,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"
2. Click the add-ons button in the navigation menu
3. Click the Get add-ons button
4. A window will pop up for you to browse
5. Type \u201cProjectSheet planning\u201d in the search box
6. Click the Free button to get the add-onYou are ready to start using ProjectSheet planning!<\/p>\nLet\u2019s get started<\/h4>\n
Input some tasks and dates<\/h5>\n
Important notes<\/h5>\n
How to use ProjectSheet Planning add-on for Google Sheets<\/span><\/h4>\nProjectSheet planning is a template made by forScale<\/a>, a company that creates easy-to-use, effective technology for project management. ProjectSheet planning is an add-on for Google Sheets\u2014use it to supercharge the way you track tasks and help you stay on track to ensure you are meeting deadlines and hitting milestones. Use the ProjectSheet planning add-on as an easy way to collaborate on any size project with your team or department.\n
What is a Gannt Chart?<\/span><\/h5>\nA Gannt Chart is a visual representation of start dates, end dates, and progress shown as a horizontal bar chart. It is a made up of columns and rows. The rows represent the list of tasks or important components. The columns represent the time scale or segments. ProjectSheet utilizes the Gannt method with Work Breakdown Structure (WBS).\n\nWBS is another project management concept that helps look at your project from a big picture standpoint and break it into detailed, actionable items. Use WBS to assign a hierarchy to the work that needs to be completed or delivered by your team. Then, the Gannt serves to give everyone a detailed understanding of both the big picture and everyone's individual working part in the completion of the project.\n
How to Access the <\/span>ProjectSheet planning Add-on<\/span><\/h6>\nIt is really simple to get add-ons for Sheets! The fastest way to get ProjectSheet planning is to click this link<\/a> that will take you directly to the web store. Simply click the Free<\/strong> button and the add-on will be added to your Google Sheets account.<\/span>\n<\/span>\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-10-15-at-2.41.43-PM-1024x596.png\")
\n\nAlternatively, you can get the add-on by following these steps:<\/span>\n\n1. Open a spreadsheet<\/span>\n<\/span>2. Click the add-ons button in the navigation menu<\/span>\n<\/span>3. Click the Get add-ons button<\/span>\n<\/span>4. A window will pop up for you to browse<\/span>\n<\/span>5. Type \u201cProjectSheet planning\u201d in the search box. <\/span>\n<\/span>6. Click the Free button to get the add-on<\/span>\n\nYou are ready to start using ProjectSheet planning!<\/span>\nLet's Get Started<\/h6>\nTo run the add-on, open a Sheet, and click Add-ons <\/strong>\u2192 ProjectSheet planning <\/strong><\/span>\u2192 Add ProjectSheet<\/strong><\/span>\n\n \n\n
![\"projectsheet](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-12-at-9.50.10-AM-1024x389.webp\")
\n\nThe add-on will work for a few minutes to set up your spreadsheets and load the sidebar. An announcement about the Pro version of ProjectSheet planning will load, go ahead and close the dialogue box for now. At first glance, we can see that the add-on has created two new tabs named Project Summary<\/strong> and Task Schedule. <\/strong>You can take a look at these sheets by clicking the tabs on the bottom left side of the sheet.\n\nTask Schedule: <\/strong>The task schedule sheet is the Grannt Chart mentioned earlier in the article. Each column represents an important piece of information about the tasks that make up your project plan, such as, Work Breakdown Structure (WBS) rank, task description, start\/end date, progress, and a weekly\/monthly calendar. This tab is going to the spreadsheet that you interact with to track your project progress.\n\nSidebar: <\/strong>Use the sidebar to customize your task schedule settings. You can change things like how you view tasks, the start date of tasks, and your timescale.\n\nProject Summary: <\/strong>This tab is a read-only spreadsheet. It pulls your project information from the Task Schedule tab, to provide an overview summary of your project. It is not editable and has a lot more information available in the report if you subscribe to the Pro version. The free version only displays the start and end date of tasks, and the percentage of completion for each task, even without the Pro features it is still a valuable visual aid.\n\n![\"projectsheet](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-12-at-10.01.02-AM-1024x545.webp\")
\n<\/h5>\n
Input Some Tasks and Dates<\/h5>\nNext, we can input some tasks into our Task Schedule and try a few different ways of manipulating them. Depending on your project management experience, this process could be a breeze, or there could be a bit of a learning curve. If you are unfamiliar with Gannt Charts or WBS<\/a>, you may want to check out a more detailed tutorial<\/a> that explains how to implement these concepts in your project planning process.\n
Important Notes<\/h5>\nAlthough this template is somewhat flexible, you need to be sure to follow some of the guidelines laid out by the designers, or you might mess up your sheets and have to start again. Make sure you only adjust the time scale using the sidebar and add any custom headers or columns into the left of the Gaant chart. In addition, if you share the spreadsheet with your team, be sure to only share it as \"View only\". If someone else gets in there and starts changing things, you might have to recreate the whole spreadsheet! Do not attempt to copy and paste content or other spreadsheets into ProjectSheet or delete columns or headers. You also cannot use custom formulas in this spreadsheet. This template is highly functional, but be sure to use it within the parameters of the design, or you may experience some frustration!","_et_gb_content_width":"","footnotes":""},"categories":[41],"tags":[44],"class_list":["post-10085","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-human-resources-processes","tag-human-resources"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/10085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=10085"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/10085\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/44271"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=10085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=10085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=10085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}