Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Duration Calculation not accurate on my sheet

Blessing Ugbo
Blessing Ugbo ✭
edited 12/09/19 in Archived 2017 Posts

Duration column on my project includes Hours and Days depending on the task. However, the duration count is inaccurate. 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    You might be seeing a discrepancy because duration in SmartSheet counts Business Days. So if your standard working days are set up as Monday-Friday then it will only count those days. Check your account settings to make sure your business days are set up correctly. Account > Account Settings > Edit working days. See my screenshot for a visual of where you will find that information. 

    If your project has been counting down calendar days in separate programs, this might be the discrepancy you are seeing. 

    accountsettings.jpg

    · Share on FacebookShare on Twitter
  • Blessing Ugbo
    Blessing Ugbo ✭

    Hi Mike,

    I have my project sheet already set up for Mon - Fri and 8H work week as indicated. See attachment if issue.

    Smartsheet.png

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    First row: 0.8333days = 6 hours 40 minutes (400m/480m). OK

    Second row: 1.25 days = 10 hours. Also OK

    Third row: I can't see enough of the data to determine correctness but I suspect it is also correct.

    Craig

    · Share on FacebookShare on Twitter
  • Blessing Ugbo
    Blessing Ugbo ✭

    Yes, but the top line "Orange line" shows 9 days which is not correct.

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi Blessing, that top line is summarizing your entire project. It looks like its rolling up everything. Do you have additional rows in there that are summing up to the total above? Its the Parent row so all children/grandchildren are going to sum up into that inital row. You may have an issue with rows being indented under that first row that shouldn't be. 

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    There is at least one more task that is under the CAD parent ... as the parent ends on 10/23/17

    Also be aware that 4 sub-task of 1 day each could show 300 days duration if they are spread out that way.

    10/11/17 to 10/23/17 is 9 working days.

    Craig

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Good points Craig. One must consider the span of days that things are being done, as well as total time on each task. The schedule impacts the duration as well as the duration impacts the schedule. They feed each other. 

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories