Holidays for 2019 not working

The holidays that I have entered for 2018 have always worked fine in calculating durations for tasks. As I program tasks for 2019, I am noticing that the holidays are not being accounted for. Christmas (12/24 and 12/25) for 2018 work fine, but after that they are no longer accounted for.

Here is the list of dates that I have entered in the system:

01/01/18, 02/19/18, 03/30/18, 05/28/18, 07/04/18, 09/03/18, 11/22/18, 11/23/18, 12/24/18, 12/25/18, 01/01/19, 02/18/19, 04/19/19, 05/27/19, 07/04/19, 07/05/19, 09/02/19, 11/28/19, 11/29/19, 12/25/19

Thanks,

Kirk

Find more posts tagged with

Account and User Management

Comments

Isaac Jose

Hello,

Thanks for your post! It sounds like holidays entered in the Project Settings > Working Days > Non-Working Days (holidays, exceptions) are not automatically adjusting or excluding themselves from your task dates and duration. I copied the dates you entered above into my own test project sheet using Copy and Paste and was unable to reproduce the unexpected behavior; 2019 holidays were correctly taken into account by my project sheet. In the below screenshot, you can see that the dependencies automatically push out the start date of any task that would otherwise begin on a holiday or weekend.

Some things you can check:

In the Project Settings, ensure that the Start date column and End date column are mapped to the correct columns in your sheet. If you have more than two date columns, they may be mapped incorrectly
Ensure that the the affected tasks have predecessors defined.
If the affected tasks do not have predecessors defined, it's possible to enter the start or end date of the task to occur on a holiday or weekend.

Some additional troubleshooting steps and workarounds you can try:

Log out, clear your browser cache and cookies, then log back in. Sometimes old data can get stuck in the browser cache. Troubleshooting Guide
Create a copy of the sheet and try to reproduce the issue Copy a Sheet with Save As New
Create a brand new sheet and try to reproduce the issue
In the Non-Working Days, try to block off an entire week as a test Define Working Days, Non-working Days, and Holidays on a Project

If the issue doesn't get resolved, then I recommend reaching out to our Technical Support Team at https://help.smartsheet.com/contact with a description of your issue, screenshots of the affected rows in your Gantt Chart, and a link to this post.

Kind regards,

Isaac J

Community

2019 holiday gantt.PNG

tamsyna

Hello, my company just experienced this same problem (account wide), and I have an alternate solution to try.

Non-working days can be set at either the account level or the sheet level. Normally, we use the account-wide level. However, we had created some project templates in 2018, prior to entering 2019 holidays at the account-wide level. The template stored those dates at the sheet level, and it turns out when we were using the templates to create new projects, it was populating the holiday dates from the template sheet level, rather than the account level. So none of our new sheets based on those templates were getting the non-working days that we entered after the template was created.

Solution: manually fix any sheets already created by setting dates at the sheet level, and then go and recreate the templates so they have the new dates.

Andrée Starå

Hi,

Excellent advice!

Thanks for sharing!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…