Forum Discussion
Referring on previous task's custom field in formula
advaipfg98...
Unlike Excel, formulas in Project's custom fields can only reference data on one task line. To do what you want will require some VBA. I can help you with that if you want.
Or, you might want to consider creating a custom report. For example, here is a simple plan
And here is a custom report showing the trend
John
- Yea, John, tell me please how I can make it? Can you show an example of VBA code? What VBA function you think I must use?
Regards!- advaepfg98...
It won't be just a simple or single function in VBA. There are several things to consider. For example, what if the adjacent task line is a summary line? What if the adjacent task has no direct relationship to the task of interest (e.g. on a different logical path)?
Comparing the finish variance of adjacent tasks is a dubious metric at best. What exactly is your boss trying to accomplish? There are better ways (best practice) to see the "trend" of a plan. For example, critical path analysis or earned value metrics.
I can certainly write code to do what you requested but I'll need some ground rules (e.g. first paragraph above) and a sample of your file.
JohnJohn-project
I seem to have solved my boss's problem. I needed a custom field "Number1" with the formula [Finish Delay] (from group "Date"). Why a custom field instead of the standard one? Because the standard one shows the delay in days, but I need it in minutes. Now, if this indicator can accurately determine the dynamics of delays. Earlier, I wanted to add an indicator that would signal if the value of this field is greater/less/equal to task n+1 than task n. But so far my boss is happy with this solution.
Thanks John!
