SS Project Plan: Auto adjust start/end date based on Resource vacation time
Hi, I have a project with Work Breakdown schedule, that has tasks assigned to resources. Our PMO policy is very strict in the way resources are allocated to tasks i.e., no resource should have more than 1 task assigned to them for the/within the same duration. This also includes vacation time. Coming from MS Project, there is a feature in there where adding vacation time against a specific resource will auto adjust the end date to accommodate for the duration and the vacation time off
For example:
Task 1 - Assigned to Resource A
- Duration: 10 days
- Original Start Date: 4/1/24
- Original End Date: 4/10/24
Vacation Planned for : 5 days 4/5/24 - 4/9/24
- New Duration: 15 days
- New Start Date: 4/1/24
- New End Date: 4/15/24
The same is applicable if the start date falls at the start of or within the planned vacation time
Thanks
Aashanram
Answers
-
Hi @Aashanram
When vacation time is scheduled for a resource, to do Automatic adjustment of task durations in Smartsheet you have to develop custom solution and there.
is not direct way to manage at this time.
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
Huma
Community Leader
-
Thank you Huma,
That is disappointing, do you happen to have or can point me towards some research material that will help build a solution?
Thanks
Aashanram
-
Hi @Aashanram
Regret for the delay in responding, somehow i missed your follow on ask.
Building a fully automated custom solution within Smartsheet itself to adjust start/end dates based on vacations is quiet challenging is what I learnt.
However, i want to direct you to request a product feature consideration on this, kindly make use of the navigation - Smartsheet Product Feedback
Huma
Community Leader
-
I too have been struggling in preparing/tracking the project, since Smartsheet doesn't auto-adjust the dates when a resource is on PTO. The only feature is to mark non-working on the whole project itself. Working with diverse teams across different geographies makes tracking the project difficult, since a holiday in one country may not be a holiday in another.
It's been a loooong time since this feature to mark PTOs at a resource level was requested.
-
@Robert Poddar are your issues resolved?
If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
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