Google Sheets Gantt Chart

Create Master Data for contacts, resources, stages & holiday dates. Enter resource email addresses to quickly and easily send on the spot reminders as well as set reminders for future dates. 

Lead Gantt is a fully dynamic Google Sheets Gantt Chart. It is divided into sections. And you can add as many sections as you like, you can add rows & columns and gantt chart will expand to accomodate the length of your project. 

Lead Gantt allows you to add quick links for reference files, checklists & other relevant documents to a task, so you can access them quickly and easily.

Easily set dependencies by allocating predecessors and lag time for each task. You can also individually select a start date for each task. Lead Gantt will dynamically update all start and end dates for your project based on your inputs.

Easily mark tasks as milestones, at risk, highlight them for team members or a combination of milestone at risk or highlighted milestone.

Easily generate dynamic monthly and or weekly gantt charts in google sheets. Lead Gantt shows combined views of baseline gantt chart as well as the actual gantt chart view in one Google Sheet.

You can easily send any task row as a reminder to the responsible person from within Lead Gantt - Google Sheets Gantt Chart. Easily one of my favourite features of Lead Gantt that I use to get on the spot task updates as well as send instant reminders to task owners.

Schedule automatic reminders to be sent to task owners on specific dates or set a number of days before the task start or end date. The reminders are automatically sent on the specified date at 8am in the morning, even if you are not logged in your project sheet at the time.

Any Lead Gantt project can be used as a main project or a mini-project or a sub-project. Each individual team can work on their own separate Lead Gantt independently and then roll-up their updates into your main or moth project. 

Easily link and connect mini and sub-projects to your main project. The connected and rolled-up Gantt Charts appear with orange sub-header and can be updated from within the main project to fetch updated task status of each linked Lead Gantt. An automatic link to the connected Lead Gantt is available to quickly access the linked mini or sub project. 

Lead Gantt is designed so you can 1) Create a project plan in Google Sheets Gantt Chart and set it as your baseline. And when you are ready, simply 2) Start Your Project to create an Actual sheet. As the project progresses make all edits to work days and start dates in your project's Actual sheet. This enables us to track projects against our planned project or project baseline.

Lead Gantt - Google Sheets Gantt Chart allows you to use any completed project as template. Simply click Pick Template & point to a previously completed Lead Gantt and a new project will be created using the Actual sheet of a previously complete project as Baseline for your new project.

Lead Gantt is built to utilise and leverage off built in Google Sheet features. This enables you to Collaborate, Share And Comment In Google Sheets Gantt Chart. You can also publish any Lead Gantt as an html page and share with all project stake holders.

Here is a walk through Lead Gantt's Interface. Built to maximise Google Sheet features and apart from being a Gantt Chart, Lead Gantt doubles as a task and workflow manager.