With sheet project settings, you can customize aspects of the sheet such as working and non-working time, Gantt display settings, and resource management.
NOTE: You must be the sheet Owner or have Admin-level sharing permissions to modify the sheet project settings.
Access Project Settings for a Sheet
Right-click any column header while in the Grid and Gantt view of your sheet and select Edit Project Settings.
The Project Settings form appears.
- You'll only see the Timeline Display settings after switching your sheet to Gantt View.
- The Resource Management section is only available with multi-user plans. Not sure which plan type you're using? See Identify Your Smartsheet Plan and User Type.
Date Range Display
Start & End Date Column—When using multiple date columns, you can select the desired columns to be used for tracking the Start and End Dates. These columns are required to add a Gantt chart to a sheet, and when using the Dependency functionality.
% Complete Column—If you'd like to overlay a % Complete indicator within the task bars in the Gantt chart, and see automated % Complete calculations occur in the parent (summary) rows, select the column which contains % Complete information in your sheet.
NOTE: The automatic % complete calculations in parent rows are based on your manually added % complete to child rows, as well as the duration of the child row tasks.
Enabled—Checking the box for Dependencies Enabled adds automated dependency functionality to the sheet. Dependency functionality allows for use of the Predecessor and Duration columns, the ability to exclude non-working days from your schedule, and the option of changing the length (in hours) of working days. It also creates automation in the Duration, Start Date, End Date, and % Complete columns in all parent rows, such that the parent rows will reflect an automated summary of the indented child tasks.
Predecessor Column—Select the column you'd like to use as the Predecessor column in the sheet. Use the selected column to create dependencies between tasks in the schedule.
Duration Column—The selected Duration column will be used in combination with the Working Days to automate the scheduling of task Start and End Dates.
Working days & non-working days—After enabling dependencies on the sheet, you’ll be able to click on Edit to select the days of the week considered non-working days for the purpose of the project. These settings will override any global account settings. Learn more about how these settings impact the automated scheduling in our article on Designating Non-working & Holidays.
Length of Day (hours)—Set the length, in hours, of working days in the project sheet. By default, Smartsheet considers each working day to include 8 hours. The length of each working day is taken into consideration when calculating dates of tasks. For example, if you create a task with a start date and a duration of 9 hours, by default, Smartsheet will automatically schedule the end date to take place the next working day. If you were to change the number of hours in a working day to 9, Smartsheet would schedule the task's end date to occur the same day it starts.
In the Timeline Display section of the project settings, you can change the Gantt timeline intervals and display formatting, start of the fiscal year, and what column information appears to the right of the Gantt bars in the Gantt chart. For example, set a Contact List column as the display label to see a list of the people assigned to tasks next to each Gantt bar.
TIP: Check Open to today's date to view current tasks in your project more quickly when you open the sheet.