I have created custom fields in both the resource and task views. When I go to insert the field from say a resource sheet to the Ghantt View it wont let me. How can I insert a custom field from one to the other? Any help would be greatly appreciated. I am working with Project 2003.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using Custom fields problem....
- Thread starter vidamj
- Start date
What do you mean "Won't let you". We're going to need a lot more information than that.
You are aware, of course, that fields such as Number1 which is visible in the Task view, is not the same as Number1 which is visible in the Resource view.
You are aware, of course, that fields such as Number1 which is visible in the Task view, is not the same as Number1 which is visible in the Resource view.
- Thread starter
- #3
I played around for a bit and can't find a simple answer to your question. Actually, I'm not surprised. Formulas are fairly limited in what they can see. I didn't find, for example, any way to work with indexes/subscripts or how to do looping and you'll need both for what you want to do
I think you'll have to combine some VBA to do the indirect stuff -- i.e. get the resource, get the task IDs that the resource is on, get each task, grab the value in Number1 and bring it back. And what about those occasions when the resource is on multiple tasks: which Number1 do you use?
The reverse (at a task and looking for Resource information) has similar issues.
The vba isn't rocket science and it sounds to me as if you know how to handle that.
Best I can suggest, then, is to use VBA to update (for example) Number2 and then use Number2 as one of the fields in the formula for Number1.
I think you'll have to combine some VBA to do the indirect stuff -- i.e. get the resource, get the task IDs that the resource is on, get each task, grab the value in Number1 and bring it back. And what about those occasions when the resource is on multiple tasks: which Number1 do you use?
The reverse (at a task and looking for Resource information) has similar issues.
The vba isn't rocket science and it sounds to me as if you know how to handle that.
Best I can suggest, then, is to use VBA to update (for example) Number2 and then use Number2 as one of the fields in the formula for Number1.
- Status
Similar threads
