Duration is incorrect and inconsistent within same sheet
What I'm trying to do:
Link "start date" and "duration" from Sheet A to Sheet B
What's happening:
I can link the cells just fine. But the duration is being calculated differently/incorrectly. Eg I have one row with a start date of 10/4 and a duration of 5 days. Based on the sheet settings, the end date should be 10/8 (which it is in Sheet A). Instead, the end date in Sheet B is 10/11, a full additional working day.
The holiday/working day settings are the same in both sheets.
Another thing I can't figure out is why this is happening inconsistently. In Sheet B, a task several rows above under the same parent has a duration of 1, and it is correctly showing the start and end dates as the same dates. But a few rows lower a task with a duration of 1 has an end date a day later than the start date.
Finally, the overall duration in the parent row is showing as a fraction?
Screenshot is of Sheet B. This shows ALL of the rows under the parent.
Answers
-
I would suggest reaching out to Smartsheet. It looks to me like there is some additional data being stored on the back-end. Maybe one of those "5d" entries for some reason is being shown as "5d" but is being stored as 5.5.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you @Paul Newcome, I will do that!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives