Comments
-
Doug: Are you referring to the Column Headers? If so, you cannot change the color.
-
Disregard User Error. However, how do I exclude weekends and just calculate M-F?
-
Remaining11 is 194 Deadline1 is 09/29/17 My formula: =Remaining11 / (Deadline1 - TODAY()) My result were 13,8571, which I know is not correct.
-
How do I only include working days (M-F)?
-
How do I only include working days (M-F)?
-
What about working days remaining only?
-
It is a good formula, except when you include task that have the same predecessors. The calc field will count the number whereas the Smartsheet formula only count it once. For example, Task 1 and 2 have the same predecessor and finish on the same day. The total duration is 1 day instead of 2 days
-
https://app.smartsheet.com/b/publish?EQBCT=ab18c1eb8260493c980b787589142463 Use the AVG Formula in the Summary Task (Execution). It Plan will not equal Actual
-
I tried the AVG and the calculations are not the same as the project settings for %complete. Any other ideas? It would be great if Smartsheet provided the formula they have hard coded in project settings for calculating % Complete
-
I tried the AVG and the calculations are not the same as the project settings for %complete. Any other ideas? It would be great if Smartsheet provided the formula they have hard coded in project settings for calculating % Complete