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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
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
- Customer Resources
- 65.3K Get Help
- 445 Global Discussions
- 144 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!