Project Plan Template for Google Sheets v3 x
UPDATE: Get the template and new training videos at http://www.jpmueller.com
Get the updated training videos at https://www.youtube.com/playlist?list=PLHwiHV7RmcJb0pfbmY_iMYTCZukarwGGJ
I needed a Project Plan Template that worked in Google Sheets. While I found several, none of them provided the functionality I needed. So what's an old school programmer to do? Built it myself! This video will walk you through the functionality.
August 17, 2017 Update: Google slightly adjusted the steps to enable the scripts that make this work. Check out this updated video on how to enable the scripts. https://www.youtube.com/watch?v=IQhWblJaYGY
August 24, 2017 Update: Several people have asked me how to manipulate and/or expand the Gantt Chart. Even though I went over this in the original video, I thought the volume of questions warranted a video dedicated specifically to modifying the Gantt Chart settings and adding columns, or expanding the chart. https://youtu.be/_qmCH2Cx70Y
September 27, 2017 Update: Check out version 5.0. I added the ability to choose the workdays so that it can support countries that have weekends that are something other than Saturday and Sunday.. It is on the Preferences tab. You can also select either Sunday or Monday for the 1st day of the work week. Lastly, I added a Holiday_Calendar tab so that you can enter additional specific non-working days.
Видео Project Plan Template for Google Sheets v3 x канала Jonathan Mueller
Get the updated training videos at https://www.youtube.com/playlist?list=PLHwiHV7RmcJb0pfbmY_iMYTCZukarwGGJ
I needed a Project Plan Template that worked in Google Sheets. While I found several, none of them provided the functionality I needed. So what's an old school programmer to do? Built it myself! This video will walk you through the functionality.
August 17, 2017 Update: Google slightly adjusted the steps to enable the scripts that make this work. Check out this updated video on how to enable the scripts. https://www.youtube.com/watch?v=IQhWblJaYGY
August 24, 2017 Update: Several people have asked me how to manipulate and/or expand the Gantt Chart. Even though I went over this in the original video, I thought the volume of questions warranted a video dedicated specifically to modifying the Gantt Chart settings and adding columns, or expanding the chart. https://youtu.be/_qmCH2Cx70Y
September 27, 2017 Update: Check out version 5.0. I added the ability to choose the workdays so that it can support countries that have weekends that are something other than Saturday and Sunday.. It is on the Preferences tab. You can also select either Sunday or Monday for the 1st day of the work week. Lastly, I added a Holiday_Calendar tab so that you can enter additional specific non-working days.
Видео Project Plan Template for Google Sheets v3 x канала Jonathan Mueller
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to Create a Gantt Chart in Google SheetsDesign a fully automated Task Tracker using Google Sheets & Forms with no access to Team MembersCreating a Gantt Chart in Google SheetsGantt View WITH TASK NAMES - Google Sheets📊 How to Track Expenses & Investments in Google Sheets 2021 / Easy Step-by-Step Spreadsheet TutorialInteractive Excel Project Management Dashboard - FREE DownloadTECH-005 - Create a quick and simple Time Line (Gantt Chart) in ExcelPERT CPM Gantt Chart using Sparkline in Google Sheets Part 1Google Project Management Professional Certificate Full CourseGoogle Sheets - Inventory Management System TemplateHow to Make a Gantt Chart in ExcelTrack Your Project with Google SheetsHow to Create a Dashboard in Google Sheets (10 steps) - Query FormulaGoogle Sheets - Alternate Colors by Row or Column, Basic to Advanced FormattingHow to Design a Google Sheets Dashboard from a Task Tracker - #GoogleSheetsDashboard #googlesheetsMake an awesome Project Management Dashboard with Excel (Free download ~ Part 1)How can I create a time tracker or punch clock using Google Sheets?Tracking Projects & Tasks in AirtableProject Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)Getting Started for CRM | monday.com