Display resources in a task view

[Sue]

Two part question relating to how resource names are displayed in a column of
a a task view:

1 - In the column, beside each resource name is a % utilization (such as
Jane Smith[38%]). How can I show only the resource name without the %
utilization (just Jane Smith)?

2 - When I have too many multiple resources, the ending ones are truncated.
How can I prevent this so I can be sure that I am viewing all the resources
in the column? (Task usage view gives me the information but does not meet
my need because I am using copy/paste of column data)

Thanks!
Sue

 

[John]

Two part question relating to how resource names are displayed in a column of
a a task view:

1 - In the column, beside each resource name is a % utilization (such as
Jane Smith[38%]). How can I show only the resource name without the %
utilization (just Jane Smith)?

2 - When I have too many multiple resources, the ending ones are truncated.
How can I prevent this so I can be sure that I am viewing all the resources
in the column? (Task usage view gives me the information but does not meet
my need because I am using copy/paste of column data)

Thanks!
Sue

Sue,
Two part answer
1 - You will need to use a spare field customized with a formula to
delete the utilization part of the string. I would use one of the string
manipulation functions, probably a combination of, Mid, InStr, and Len
to parse the Resource Names field.

2 - Text based fields in Project are limited to a maximum (displayed) of
255 characters. I'm guessing your assigned resources exceed that limit.
There are various options. One is to shorten the resource names so they
take up less space (do this on the Resource Sheet). Another is to split
the task into smaller pieces so fewer resources need to be assigned to
each task part. A third might be to combine resources into resource
sets. For example, instead of showing Joe, Bill and Fred (who are all
data clerks) as individuals, group them together as a set with a
resource name of "Data Clerks" and a Max Unit value of 300%.

Now, depending on why you are copying and pasting resource assignments,
there may be a better approach.

Hope this helps.
John
Project MVP

 

[Mike Glen]

Hi Sue,

A simple solution is to use the Initials field and show that in the Gantt
Chart view instead of the Resource Names.


Mike Glen
Project MVP