Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Owner
  • Admin

Define working days, non-working days, and holidays on a project sheet

Use the Project Settings to define working days, non-working days, and holidays at the sheet and account levels.

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Non-Working Days entered manually must be updated in a sheet created from a template.

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

  • If you are viewing your Gantt chart in days, non-working days appear highlighted in grey and holidays in pink.
  • You can manually schedule tasks and milestones to start on a non-working or holiday, but their end dates cannot occur on these types of days.
  • Non-working days and holidays are not included in duration calculations.

A System Admin of a Business or Enterprise plan can configure working, non-working, and holidays at the plan level.


Working days, non-working days, and holidays at the sheet level

Use the Project Settings form to set the length of working days (in hours), designate days of the week as non-working, and specify dates of holidays. 

 

You must enable Dependencies on the sheet to configure these settings. 

 

  1. Select the Project Settings icon in the Gantt chart header or right-click on any column header
  2. Select Edit Project Settings.
    View of the Project Settings window.
  3. Go to Working Days > Edit.

    View of the Working Days edit window.
     
  4. Select the checkbox for each day of the week your team will work on the project.
  5. 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.
  6. Enter any specific dates of non-working or holidays in the Non-Working Days (holidays, exceptions) section.
  7. Select OK.

Working days, non-working days, and holidays at the account level

If you are a sheet's System Admin, you should keep the following tips in mind when setting account-level working days, non-working days, and holidays:

New sheets with dependencies enabled inherit any settings you set.

New sheets created from templates always inherit the working days of the template regardless of the settings for account-level working days.

  1. in the upper left corner, select Account > Account Admin.
  2. On the left side of the Account Administration form, select Account Settings.
  3. Under Working Days, select Edit.
  4. Select the checkbox for each day of the week your team will work on the project.
  5. 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.
  6. Enter any specific dates of non-working or holidays in the Non-Working Days (holidays, exceptions) section.
  7. Select OK.