Let me show you how it's done.

Entry types including parent tasks, child tasks, milestones, complete tasks and past due. Gantt colors, identifying today’s date in the Gantt chart and progress sparkline bar charts.

Linking to other tasks, basing tasks on today’s date and avoiding a dependent task from starting on a nonworking day.

Changing working days, adjusting work days per week, adjusting work days per month and managing the holiday calendar.

Changing the Gantt chart start date, how to always start on the current week, how to always start on the previous week, changing the starting day of the work week, changing the Gantt chart interval and adding additional columns to the Gantt chart.

Indenting and outdenting tasks, rolling up tasks and a reminder about how the Fixing Formulas feature works and to be careful when dealing with rolled up tasks.

Adding an action item, automatic generation of Unique IDs, creating a new AI from the currently selected project plan task, using standard Google Sheets filtering, filtering based on the currently selected project plan task and clearing the filter.

Identifying risks as yellow or red, adding comments to a plan, assigning tasks, inserting notes and introduction to action items.

Changing the spreadsheet locale and reformatting date columns.

How to plan tasks that lead up to a predetermined date. I walk you through planning a party that has to take place on a specific date.

How to change column headings to your local language. Changed Gantt chart only highlight non-working days if the Gantt interval is daily.

Walk through of how to enable the scripts on your sheet. This must be done the first time you use a new instance of the sheet.

Learn how to check if your resources are over-utilized in your JPMG Project Plan Template for Google Sheets.