Duration Column with Dependencies Enabled

08/31/20
Accepted

Hi All,

So with the duration column, we have decided to enable the dependencies however the calculation seems a bit off

To test it we but in 2 days for duration

Dependency is Start Date and Due Date

We thought that if the Duration is two days. We put in a Start Date of 9/1/2020, then the Due Date should be 9/3/2020. Instead it is as if Smartsheet counts the date entered as a whole day when the day should begin the next full day.

Any tips or feedback is greatly appreciated!!!



Best Answer

Answers

  • StefanStefan ✭✭✭

    Hi @Leslye Jackson,

    why don't you enter the actual start date?

    Start date is a full 8 (or whatever) hour working day. So if you say the task takes 2 d, that's 16h in your settings and this results very correct in the two days 1. + 2. of September being used.

    Hope this helps

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

  • @Stefan Thank you for your feedback so I tried that but it literally didn't change the results. I put in 24 hrs and it counted two days.



  • @Paul Newcome

    Thank you so much for your feedback on this!! All of you guys rock!!!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

  • StefanStefan ✭✭✭

    Hi @Leslye Jackson ,

    also happy to help!

    As @Paul Newcome already pointed out, the dates your sheet shows are correct.

    The connection between the figures in DURATION and the start/end date is determined by the section "Working days" in your project settings. Everything you change there influences the calculation of the end date.

    For a deeper understanding you may check these articles:


    Greetings

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Sign In or Register to comment.