Duration Column not calculating correctly

julieg

Hello,

We've noticed on our project plan that the Duration column is not calculating correctly. It shows a total duration of 156,648 days. Our start date and end date range is the following 4/20/22 to 3/20/23. That is one Issue.

The other is that our Communicate Row (Sub Heading) shows 3/20/23 as the end date but the main Heading for the project plan shows an end date of 9/27/22 instead of showing the end date of 3/20/23. Thanks for your help. Please see attached screen shots.

Genevieve P.

https://community.smartsheet.com/discussion/comment/342767#Comment_342767

Hi @julieg

Is there any possibility that the year on this cell was put to the wrong date?

Eg. instead of 2022, could that row have 3022? Or 2422? Since we're only seeing the end two digits, it seems like perhaps the first part of the year is wrong. This would explain why the top Parent row is going to 22 as well, instead of 23.

Try formatting the column to see the full year:

Thanks!

Genevieve

julieg

Thank you for all of your help. It was the date format that was hiding an incorrect date with a 2026 start and end date. As soon as i switched to a long date format I could see the incorrect entries and changed them to reflect 2022-2023. This also caused the correct project end date to appear on the parent row at the top of the project plan.

Thank you again - you guys are great!

Paul Newcome

Are there any dates in any of your hidden rows that are extended? I would set up a filter to show dates that are outside of the range you have displayed in your screenshot to try to figure out exactly which rows are causing the issue.

julieg

Hello Paul,

Thank you for responding. I had already checked the date ranges to be sure there was nothing outside of those. I decided to create a filter to be sure, and zero rows were returned. The filter checked for any dates outside of 4/20/22 to 3/20/23. I'm a bit stuck on this one, 156,000 plus days just makes no sense. Please let me know if you have any other thoughts on this or the second issue i mentioned above. Thank you so much for your help.

Julie

Andrée Starå

Hi @julieg

I hope you're well and safe!

Strange!

Try making a copy of the sheet to see if it's still the same issue.

If that doesn't change anything, and If you haven't already, I recommend reaching out to the Smartsheet Support Team.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

https://community.smartsheet.com/discussion/comment/342767#Comment_342767

Hi @julieg

Is there any possibility that the year on this cell was put to the wrong date?

Eg. instead of 2022, could that row have 3022? Or 2422? Since we're only seeing the end two digits, it seems like perhaps the first part of the year is wrong. This would explain why the top Parent row is going to 22 as well, instead of 23.

Try formatting the column to see the full year:

Thanks!

Genevieve

Paul Newcome

@julieg My apologies. I meant to create two separate filters. One to check for less than and see what is returned, clear it, then another one to check for greater than.

Andrée Starå

@Genevieve P.

Good "possible" catch! 👍️

julieg

Thank you for all of your help. It was the date format that was hiding an incorrect date with a 2026 start and end date. As soon as i switched to a long date format I could see the incorrect entries and changed them to reflect 2022-2023. This also caused the correct project end date to appear on the parent row at the top of the project plan.

Thank you again - you guys are great!

Andrée Starå

@julieg

Excellent!

Happy to help!

Genevieve P.

https://media.giphy.com/media/jV6XStJKj5mLp9wCwH/giphy.gif

Glad you were able to sort it out! 🙂

Paul Newcome

Happy to help. 👍️