Selective non working days/holidays for sheet level
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?
Answers
-
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
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
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.
-
Hi @bgoodman -- any resolution? Shipping lead times are a good example -- this can continue through holiday exclusions
-
@Ryan E no not yet :/
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!