How it works
How to Create a Correct Task
SlickGantt will create a task for each row in your sheet that respects all these 4 conditions:
There is a value in the column specified for the Task ID (=not empty)
There is a value in the cell specified for the Task Name
There is a valid date in the cell specified for the Starting Date
There is a valid date in the cell specified for the End Date
If one of these conditions is not true the row will be skipped and you will not see the task in the gantt
Task ID Field
The task ID field must contain a unique identifier for the task. Having more than one task with the same ID will create issues in the visualization, the graphical interaction with the task (e.g. dragging actions) and in the value updates.
Note that the character " , " is going to be ignored.
TIP: use something like "Task 1" or something else you can remember (avoid long alphanumeric strings): you'll need the ID if you want to setup some dependencies
Progress Field
The field with the progress information must be in "Percent" format. If the value is expressed in integers (a number between 1 - 100) all your tasks will look like completed and the value of the field will be reset to a percentage (number between 0 - 1)
Dependency Field
You can set a dependency between two (or more) different tasks. This is very useful if you want to quickly update the date for a block of tasks when one of them (they depend on) is late.
To setup a dependency for a task you will add in the field specified for dependencies the Task ID of the task it depends on.
A task can depend on more than one task: in that case you can add multiple task IDs separated by a comma "," (e.g. "Task1,Task2")
The image below shows an example of a situation where Task 8 depends on Task 7:
Task Type (Main, Sub, Milestone)
In a project there are activities that are grouped together in phases or sprints. You typically want these tasks to be easily identifiable with a color code.
You can specify the type of task using the column "Task Type". It accepts 3 possible values:
Main Task: being this is the main task, it will take a different color from the task before it.
Sub Task: it's a task depending from the previous available Main task. It will inherit the same color of the previous Main Task
Milestone: this activity will be marked with a strong red color, to differentiate it from the rest of the tasks
If the Task Type field is empty, the task will use the standard color (gray)
Resources
The resources field accepts names of your resources separated by a comma. E.g. "Agnes,John".
Note that you should not add spaces between the comma and the next name.
Working on Multiple Sheets in the Same Spreadsheet
You can configure SlickGantt on several sheets in the same spreadsheet: in the Configuration page you will be able to select the sheet you want to use and the right columns in that sheet.
Note that SlickGantt will remember the name of the columns you used in another sheet within the same spreadsheet and it will propose you the columns with the same name: if you want to use something different you need to explicitly change it.