Gantt chart might be one of the simplest project management tools out there. If you have attempted to create Gantt charts in Excel certainly using the Airtable Gantt app will be a huge improvement. It presents visually the diagram based on the tasks from the selected Airtable view. It also allows adjusting task length and placement by dragging the elements on the canvas. The most crucial function is the ability to show dependency between tasks and create a critical path to show you if one task starts before another.

With big-scale projects containing multiple tasks, adjusting things by hand is not the best option neither is manually changing start and end dates. Airtable does not allow for circular references so that won’t help either. This problem can be easily solved with a bit of code in the Airtable “Scripting” block. Relax, we are no-code friendly so we have written this code for you.

To start the script in-line you need to have the first starting date for the first task of the project and the duration of all tasks. Starting from there, the script will set the end date for the first task and follow on to each successor task, and set their starting and ending dates.

The script excludes Saturdays and Sundays automatically. If the duration of your task is 5 days but the starting date falls on Thursday, the duration of the task will be extended by 2 days to adjust for the weekend. If you prefer to work on weekends — do reach out to us and we will happily adjust the script for you!