In this video I walk you through how to change the Gantt Chart Interval, how to override the Gantt Chart Start Date and how to expand the entire Gantt Chart so that it shows more columns.

WANT TO LEARN MORE ABOUT MY PROJECT PLAN TEMPLATE FOR GOOGLE SHEETS? Go to http://www.jpmueller.com

I needed a Project Plan Template that worked in Google Sheets. While I found several, none of them provided the functionality I needed. So I built it myself!

The Template Interface
– Making your own copy
– Enabling Google scripts
– Release Notes (New Features and Bug Fixes)
– Backlog
– Entering project tasks
– Hidden rows & columns
– Don’t enter data in blue columns
– Show calculations
– Fixing Formulas
– Removing Previous Data

Your First Project
– Parent tasks
– Child tasks
– Configurable milestones symbol
– Completed task indications
– Past Due task indications
– Contextual Gantt Colors
– Gantt chart timeframe manipulations
– Today’s date is highlighted
– Progress Sparkline Barcharts show % complete, % behind schedule, and % past due

Dependencies
– Linking to other tasks
– Dependencies on today’s date
– Dependent tasks to not start on a nonworking day

Calendaring Functionality
– Configurable working days
– Configurable Work Days per Week
– Configurable Work Days per Month
– Configurable Holiday Calendar

Gantt Chart Manipulations
– Changing Start Date
– Can start on current week
– Can start on previous week
– Configurable starting day of week
– Configurable Gantt Interval
– Can expand Gantt chart

Advanced Task Manipulation
– Indenting and Outdenting Tasks
– Rolling Up Tasks
– Ability to insert your own columns

Action Items
– Unique ID automatically generated
– Creating a new AI from currently selected PP task
– Supports standard Google Sheets data filtering
– Filtering based on currently selected PP task

Using your plan to collaborate
– Red & Yellow Risk and Due Status highlighting
– Supports Google Sheets Comments
– Supports Google Sheets Task Assignents
– Supports Google Sheets Notes

Localization
– Supports Google Sheets standard Locales configurations
– Supports international date formats
– Configurable column headings to local language

Please take the opportunity to connect and share this video with your friends and family if you find it useful.