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?



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.