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

Use 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.

Keep this in mind about non-working days and holidays:

  • Non-working days and holidays aren’t included in the duration calculations.
  • If you view your Gantt view 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 can’t occur on these days.

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

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

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

Follow these steps to edit your working days, on-working days, and holidays for your sheet: 

  1. Select the Project Settings  Adjust settings.  gear icon in the Gantt view header, or right-click on any column header in grid or Gantt view, and select Edit Project Settings. 
Dependency settings in the Project Settings dialog
  1. In the Working Days section, select Edit.
  2. Select the checkbox for each working day, and leave the checkbox blank for non-working days each week.
  3. Enter a value representing the number of hours per working day in the Length of Day (hours) field. By default, Smartsheet considers each working day to include 8 hours.
  4. Enter any specific dates of non-working or holidays in the Non-Working Days (holidays, exceptions) section.
  5. Select OK.
Working days menu

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

If you are a plan’s System Admin on a Business or Enterprise plan, follow these steps to set and manage working days, non-working days, and holidays for your entire account.

  1. Select your user icon and then select Admin Center.
  2. Scroll down to the Working Days box and select Working Days.
  3. In the Working Days section, select the days of the week.
  4. In the Length of days (hours) box, enter the number of hours. 
  5. In the Non-Working Days box, enter dates in the given format to denote holidays and exceptions. 

Keep in mind

  • If a task's start date is a non-working day or holiday, the task considers that day a working day regardless of the settings.
  • Your selection applies to all new sheets users create on the plan. Your changes don't affect existing project sheets.
  • New sheets created from templates always inherit the template's working days regardless of the settings for account-level working days.

Learn more about Admin Center capabilities.