Adding BankHolidays while disabling dependencies

tfassnacht

Hello SmartSheet community,

 

I would like to add bankholidays under a "depencies disabled" mode.

It this possible ?

 

I take it that with a "dependency enabled" mode, that's already feasible.

 

https://help.smartsheet.com/articles/516392-defining-working-non-working-holidays-on-a-project-sheet

 

Best

 

Alejandra

Hello,

At this time, dependancies must be enabled in order for non-working days or holidays to be excluded in the duration calculation.

As a workaround, you could create a formula using the NETWORKDAY function to calculate the number of days between two dates, adding 1 day to the result if the start date is a non-working day.

The NETWORKDAY function allows you to enter the dates you would like to exclude. More information on this function can be found here: https://help.smartsheet.com/function/networkday