Selective non working days/holidays for sheet level

bgoodman

Hi there. I currently have all my project sheets set to exclude non working days and holidays because the overwhelming majority of our work is done during weekdays excluding holidays. However some of the activities have a duration that is irrespective of that. For example, there may be an experiment that takes 6 weeks from start to finish b/c it is running over that 6 week period uninterrupted. If I set it up for say end of December and include a 6 week duration, it appears as if takes 7 weeks b/c of the Christmas holiday/New Years holiday that is blocked off in the project settings. Now of course I could manually fix this by changing the duration to match the correct end date (in this example making it 5 weeks), however that is a problematic solution in that if the experiment gets moved to January, it's now showing as ending early. In order for this to work, I'd have to remember every instance on the sheet where a duration was tweaked to account for holidays which is not ideal. Are there work-arounds to override project settings on a row by row level?

hollyconradsmith

Hi @bgoodman,

Would adjusting the project sheet settings help here? or is it only specific items you wish to have ignore holidays?

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

bgoodman

Hi @hollyconradsmith thank you for the response. It is only specific items I wish to ignore holidays. I currently have the project settings set to exclude holidays, but some activities in the sheet are no impacted by holidays/weekends and I am unable to capture this accurately at the moment.

Ryan E

Hi @bgoodman -- any resolution? Shipping lead times are a good example -- this can continue through holiday exclusions

bgoodman

@Ryan E no not yet :/

Kurt Robohm

There is an article that describes how to plug in an elapsed time duration that overrides non-working and holiday settings, basically just adding an "E" before the duration (E3d) in the duration column. Worked great for me. Here's the article.

https://community.smartsheet.com/discussion/17951/independent-work-days-for-tasks-or-resources