Define Working Days, Non-working Days, and Holidays on a Project Sheet

Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

For more information about plan types and included capabilities, see the Smartsheet Plans page.

The sheet owner and collaborators with Admin access to a dependency-enabled project sheet can configure non-working days and holidays for the project, as well as the length of working days (in hours).

Here are a few things to keep in mind about non-working days and holidays in Smartsheet:

  • When the Gantt chart timeline is displayed in days, you'll see non-working days highlighted in grey in the Gantt chart and holidays highlighted in pink.
  • Tasks and milestones can be scheduled manually to start on a non-working or holiday, but end dates can't occur on these types of days.
  • Non-working days and holidays aren't included in duration calculations.

A System Admin of a Business or Enterprise plan can also configure working, non-working and holidays at the account-level. The settings will be applied to any new sheet with dependencies enabled created by licensed users on the account. (Not sure which plan type you have? See Identify Your Smartsheet Plan and User Type.)

TIP: Open the User Management screen to find a list of licensed users on the account.

Sheet-level Working, Non-Working, and Holidays

You can use the Project Settings form for a sheet to set the length of working days (in hours), designate days of the week as non-working, and specify dates of holidays. Non-working days and holidays are not included in duration calculations and can be set differently for each project sheet.

NOTE: Dependencies must be enabled on the sheet in order to configure these settings. For information about how to enable dependencies, see the article Enabling Dependencies and Using Predecessors.

  1. Click the Project Settings icon in the Gantt chart header or right-click on any column header and select Edit Project Settings to display the Project Settings form.
    Project Settings form
  2. Under the Working Days section, click Edit to display the Working Days form.
  3. Select the checkbox for each day of the week your team will be working on the project.
  4. Enter a value representing the number of hours per working day in the Length of Day (hours) field if your team works more or less than 8 hours per day.
  5. Enter any specific dates of non-working or holidays in the Non-Working Days (holidays, exceptions) section.
    TIP: You can copy and paste dates using keyboard shortcuts or you can click the calendar icon to the right of this field to select dates from a calendar picker.
     
  6. Click OK to close the Project Settings form.

Account-level Working, Non-Working, and Holidays

A System Admin on a Business or Enterprise plan can configure working day settings at the account-level. The settings will be applied to new sheets with dependencies enabled created by licensed users on the account. New sheets created from templates will always inherit the working days of the template regardless of the settings for account-level working days. See Templates: Create Your Own or Use One from the Solution Center for information about creating your own templates.

  1. Click Account in the upper left corner, then select Account Admin. The Account Administration form appears. Click Account Settings on the left side of the form.
  2. Click the Edit button underneath the Working Days heading to configure the settings.
  3. Select the checkbox for each day of the week your team members work on projects.
  4. Enter a value representing the number of hours per working day in the Length of Day (hours) field if your team works more or less than 8 hours per day.
  5. Enter any specific dates of non-working or holidays in the Non-Working Days (holidays, exceptions) section.
  6. Click OK to save your changes.