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...
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!
Regards!