Resource Management

BESP10 ✭✭✭✭✭✭

If I have a taks that is going to take 300 hours to do and I have two resources available to each work 40 hours a week, and I enter a start datem how do I get smartsheet to automatically update the end date based on the 300 hours estimated and the hours they are available to work?

Thank you


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @BESP10

    You could split this task into two rows, with 150 hours as the Duration per person. Then when you add in the Start Date, if you have your Project Settings turned on, it will auto-fill the End Date based on these hours (skipping over weekends).

    Keep in mind that you will want to ensure your Working Days and hours are set up correctly in your Project Settings:

    You can read more about Project Settings in our Help Center (click here).