Feb 12, 2018 Skipped

Jennifer Levey

All of my tasks are skipping over and not including this date (yesterday) in their calculations. I do not have this set as a holiday in the main settings. Is there a holiday/day off setting for the specific sheet?

Shaine Greenwood

Hi Jennifer,

There is! If you right-click any column header and select Edit Project Settings, then select Dependency Settings. Click the Edit button under Working Days and edit holidays here.

If you don't have holidays in the sheet, then you may have formulas that have holidays in their calculations. More info on different date functions can be found in our help center: https://help.smartsheet.com/functions

A few date functions that come to mine which allow you to include holidays are NETWORKDAY, NETWORKDAYS, and WORKDAY.

Jennifer Levey

Shaine - thank you, thank you. There was an incorrect holiday in there. It fixed it. I love this forum!

Shaine Greenwood

Glad to help!