Project Plans still allowing work on holidays

Pamela Wagner

We've not noticed it before now but even though my Non-Working Days seems set up correctly, the plan is still allowing those days to be scheduled. Anyone see this before and resolve it?

Matt Johnson

Hi @Pamela Wagner

That's an interesting question and I learned something too while researching the answer.

Basically, although setting up non-working days excludes those days in duration calculations, you can still manually schedule tasks and milestones to start on a non-working day.

As for the solution, maybe set up an automation that highlights the row a certain color if one of those dates is selected.

Here's the help article where I found this information:

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

I hope that helps.

Matt

Matt Johnson

Hi @Pamela Wagner

That's an interesting question and I learned something too while researching the answer.

Basically, although setting up non-working days excludes those days in duration calculations, you can still manually schedule tasks and milestones to start on a non-working day.

As for the solution, maybe set up an automation that highlights the row a certain color if one of those dates is selected.

Here's the help article where I found this information:

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

I hope that helps.

Matt

Pamela Wagner

@Matt Johnson, thanks for the reply (sorry I was on PTO for a bit). Totally strange that its set up that you can start but not finish a task on a blocked out date. Not sure I understand the logic in that. I do have templates created for our project plans and will create conditional formatting that will highlight when this occurs. Good tip!