You can use Spreadsheet.com for your team's Project Management needs. With Gantt views, you can track tasks, due dates, dependencies, and more. Within Gantt views, you have the ability to adjust Project Management settings like specifying which column to use as the status column or adjusting which days of the week the team will work on a project.
Enabling Project Management
In Spreadsheet.com, Gantt views require you to enable project management which then requires your workbooks to have at least six specific columns:
- Start date column (Date)
- End date column (Date)
- Assigned user column (User)
- Duration column (Duration)
- % Complete column (Percent)
- Status column (Select)
And defaults to using the primary column as the "Task" column.
Each of these columns (except the primary column) must match a particular data type. Although you can specify any column that matches that data type and, when creating a new Gantt view, Spreadsheet.com will create any missing columns for you.
When creating your Gantt view, Spreadsheet.com automatically enables project management and allows you to adjust columns as needed.
Editing Project Management settings
After creating your Gantt view, you can edit the Project Management settings at any time by selecting the Project Management button in the toolbar.
This will open the Project Management settings menu, where you can:
- Enable and disable project management (project management is required for Gantt views)
- Edit which column project management will use for each of the required columns (e.g., Start date, End date, Duration, % Complete, etc.)
- Specify which days count as working days (e.g.,M-F, Sat-Sund, Fridays off, etc.)
- Specify workday start and end times
- And Enable dependencies.
Note: Columns used for Project Management can have their setting's changed but lock their data type and hierarchy rollup settings.