Mismatch between custom duration formula and project settings duration column
Why do I often get a 1 in a custom duration calculation of same-day work vs. project settings calculation, which shows 0?
During some import troubleshooting, I created a "baseline duration" and "revised duration" column to compare my own formula for calculating duration to the durations provided by project settings.
My formula for calculating "Baseline Duration" is here:
=NETWORKDAY([Baseline Start Date]@row, [Baseline End Date]@row)
"Revised Duration" Project settings look at Revised Start Date and Revised End Date.
So, for the most part, these numbers will match. Here are some circumstances where they do not.
Baseline Start Date 10/27/20
Revised Start Date 10/27/20
Baseline End Date 10/27/20
Revised End Date 10/27/20
Baseline Duration 1
Revised Duration 0
Best Answer
-
Because the function you are using considers that as 1 day whereas the project settings see it as a milestone which has a zero day duration.
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!
Answers
-
Because the function you are using considers that as 1 day whereas the project settings see it as a milestone which has a zero day duration.
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!
Help Article Resources
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
Check out the Formula Handbook template!