Forum Discussion
Referring on previous task's custom field in formula
Hi everybody!
I need to set indicators in custom fields that would implement a comparison of the custom field Number1 from the current task with Number1 from the previous task. How can I set a lin...
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!
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.
John
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.
John
John-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!- adv...
I'm glad you were able to meet your boss's needs. Thanks for the feedback.
John