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

Options

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

  • Humashankar
    Humashankar ✭✭✭✭✭
    Options

    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

  • Aashanram
    Options

    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

  • Humashankar
    Humashankar ✭✭✭✭✭
    Options

    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