Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Owner
  • Admin

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  Brandfolder Image 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. 
Brandfolder Image
Dependency settings in the Project Settings dialog
  1. Go to Working DaysEdit.
  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.
Brandfolder Image
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. A new window automatically opens the Account Settings page of the Account Administration box.
  4. In the Working Days section, select Edit.
  5. Use the check box to select the days of the week and enter the number of hours per day. In the Non-Working Days box, either type in dates in the given format or use the calendar picker to denote holidays and exceptions. 

Keep in mind

  • New sheets with dependencies enabled inherit any settings you set.
  • 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

Brandfolder Image
admin center working days