How to add a column which will be linked to the Resource Names?

[Peter]

I want to add a column which will be linked to the Resource Names column.
The linked column will show the initial of the resource.


Thanks,

Peter

 

[Jan De Messemaeker]

Hi,

You don't have to link. Just insert the column "Resource Initials"
HTH

 

[Gérard Ducouret]

Hello Peter,
The Initials column in the resource sheet view doesn't do that ?
What do you want more ?
Gérard Ducouret

 

[Peter]

Hi Jan,

The design of the Project may be a weird one. It does not use subtasks but
a task is broken down into 7 rows with a column Task ID containing a unique
value within the 7 rows and a column Feature ID containing same value for all
7 rows. There is an existing linked column that I cannot figure how it is
created. When I changed the Resource Names for the 3rd row of the 7 rows,
all 7 rows of the linked column will be changed to the Resource Initials of
the new value of the Resource Names.

Feature ID Task ID Linked Column Resource Names
001 A P David
001 B P Tommy
001 C P Peter
001 D P Robert
001 E P Charles
001 F P Doug
001 G P Jim
002 A M David
002 B M Tommy
002 C M Mary
002 D M Robert
002 E M Charles
002 F M Doug
002 G M Jim


Thanks,

Peter

 

[Jan De Messemaeker]

Is this Microsoft project?

 

[Steve House [Project MVP]]

Jumping in, you're right - it is a weird way to organize a project, running
totally counter to the Work Breakdown Structure that is at the core of the
Critical Path methodolgy that is the basis of Project's design and I'm
certain that sooner or later the implications of this non-standard WBS are
going to rear up to bite you and get you into a major bind. Be that as it
may, what you're asking is certainly do'able but you'll have to implement it
in VBA. You can't use the Resource Initial column from the resource table
directly while renaming it the Linked Column because if you do, having your
procedure write "P" into the linked column for all tasks with Feature ID 001
in your example will assign "Peter" in the Resource Name column for all
those tasks. Instead, use one of the Text fields 1 thru 30 and rename it.
Then you'll need to write a VBA procedure that is triggered by a change in
the resource name column for any of the tasks that a:retrieves and saves the
resource initial from the resource table for the name you entered, b:saves
the task feature ID for the task you've modified, c:locates the first
instance of that task feature ID in the table, d:steps through all rows
matching that id and writes the saved initial into the linked column field
for each task in turn.

 

[Peter]

Hi Steve,

In my previous post, I just use the name Linked Column to indicate that the
column is a linked column (one with a triangle sign on the lower right
corner). The linked column is actually the Text4 field which is titled TS
Resource. There is no VB script (at least I don't find any in the directory)
but somehow changing the 3rd row of Resource Name column will put the
Resource Initial to all 7 rows of the TS Resource for the Feature ID 001. I
have tried changing Initials column of the Resources to see whether it is
really the Initials value being updated to TS Resource and it is. It is a
mystery how this works. But keep in mind that I'm a newbie to Project .


Thanks,

Peter