How to ignore "working days" to get "consecutive days" at duration?
Dear All,
In a project plan "working days" are usually Monday through Friday. But how can I handle a situation, e.g. when at a construction project concrete get cast and the concrete needs e.g. 3 days to harden. The concrete is also hardening on weekends.
In Microsoft Project there they have the feature "fdays" ("f" stands for consecutive; - German version). Question: Is there also such a feature in Smartsheet available, or is it maybe possible to shut out weekends, holydays, etc., by a formula, either?
Any answers to this matter will be greatly appreciated! Thanks to everyone who contributes!
Hans P. (from Germany)
Best Answer
-
Hi @Porzel Hans
Yes! You can use elapsed time in Smartsheet to indicate when a Task should ignore Holidays and weekends. To do this, add an e before the duration, like so:
e3d
See: Enable Dependencies and Use Predecessors
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @Porzel Hans
Yes! You can use elapsed time in Smartsheet to indicate when a Task should ignore Holidays and weekends. To do this, add an e before the duration, like so:
e3d
See: Enable Dependencies and Use Predecessors
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Dear Genevieve,
Fantastic, I'm thrilled! Thank-you dearly!!!
Happy smiles!
Hans ... from Germany
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!