SS Project Plan: Auto adjust start/end date based on Resource vacation time

Aashanram

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

2024-03-15_11-23-00.gif

Humashankar

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

Aashanram

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?

Humashankar

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

Robert Poddar

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.

NicoLHC

@Robert Poddar are your issues resolved?