Duration Column not calculating correctly
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.
Best Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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!
Answers
-
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.
-
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
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@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.
-
Good "possible" catch! 👍️
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Glad you were able to sort it out! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives