best free gantt chart software for google sheets

So, when we copy the same formula for subsequent cells-which we do in the next step-using the dollar sign like this makes sure it always references that value in B4, which is the start of the first task.Īfter you press the “Enter” key, click on the cell again and then double-click the little blue square. Google Sheets uses the dollar sign ($) character to “lock” a row or column-or, in our case, both-when referencing a value. In the formula, the is always going to be an absolute value. It will look like this: =INT(B4)-INT($B$4) To do this, you first convert each date into an integer and then subtract it from the first task’s start date: ( - ).

To calculate “Start on Day,” you need to find the difference between each task’s start date and the start date of the first task. You can simply copy the cells underneath, directly reference them, or re-write them if you want. The “Tasks” heading will be the same as above. It should look like this:Īfter you get the headings in place, you need to calculate the start day and duration. The table will have three headings to generate the Gantt chart: tasks, start day, and duration (in days) of the task. Next, make a similar table off to the side or underneath the previous one that will serve as a way to calculate the graphs in each portion of the Gantt chart. Fill in each cell with the project’s details. You’ll need one for tasks, start date, and end date.

First, create a small table and insert a few headings into the cells to get started.

Best free gantt chart software for google sheets