Public Holidays

edited 12/09/19 in Smartsheet Basics


When we update our public holidays, it doesn't seem to pull through on project plans that were created 2017. 

Can someone please advise how we can get smartsheets to automatically update projects plans that were created in 2017 with 2018 public holidays? 

Please note that I have updated smartsheets with the latest public holidays in the account settings.




  • Hello Delycia,

    There currently isn't a way to have Smartsheet retroactively update the designated holidays in all sheets based on a change to the account setting for holidays—the holidays will only be added to newly created sheets after you've made the change.

    You'll need to go into each sheet and manually add the holidays in each sheet's Project Settings. Right-click any column header and select Edit Project Settings > Dependency Settings, then click Edit under Working Days. You may be able to copy your account level holidays and paste them into the sheet level Project Settings using Ctrl + C and Ctrl + V.