Define Non-working days in sheet level

Nahom

I want to add non-working days in a sheet level. Tried to list down the non-working days in the Account Setting but it only works for project management and gantt chart. The NETWORKDAY/S formula makes the formula very long to list down all the holidays and slows the page. Is there any possible work around or any guidance. Thanks.

Alejandra

Hi @Nahom,

Working and non-working days can only be set on project sheets where dependencies are enabled. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet. 

If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/516392-defining-working-non-working-holidays-on-a-project-sheet

Alejandra

Hi @Nahom,

Working and non-working days can only be set on project sheets where dependencies are enabled. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet. 

If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/516392-defining-working-non-working-holidays-on-a-project-sheet

Dale Heincelman

Based on the documentation from the link provided there is an issue.

The documentation says if the Sys Admin adds non-working holidays it will ONLY apply to new sheets with dependencies enabled.

After testing this ONLY applies to NEW sheets. It does not apply to the use of creating a sheet from a template or doing a "Save as New" to make a new copy of an existing sheet.