T
Teeder
Is it possible to display only the name of the project in the project field
of the resource usage view without the path?
of the resource usage view without the path?
J
John
Teeder said:
Teeder,
You must be dealing with a resource pool file where only one of the
sharer files is open. As long as the assignment row in the Usage view
points to a file that is not open, the Project field will contain the
full path. You can however, designate a spare text field and then strip
off just the file name portion of the path and display that.
John
Project MVP
T
Teeder
How?
Teeder
Teeder
John said:
J
John
Teeder said:
Teeder,
Actually, to do what I suggested would require some VBA - it can't be
done with a formula since formulas do not apply to assignments. However,
there is an easier way.
1. In each of the sharer files display the Resource Usage view.
2. Add a spare text field (e.g. Text1) to that view
3. Filter the view for "Assignments" equal "yes".
4. Enter the filename into the first assignment spare text field and
fill down.
Now when you look at the master file, the spare text field will display
only the file name.
John
Project MVP
T
Teeder
John......you are the king, and I bow before you!!!
Teeder
Teeder
M
Mike Glen
Steady - he'll want a throne and a crown now! 
Mike Glen
Project MVP
Mike Glen
Project MVP
J
John
Teeder said:
Teeder,
The "king" died of an overdose many years ago although there are those
sightings...... I am simply a jester in the court - a lot of flash and a
few tricks up my sleeve.
You're welcome, and thanks for the feedback.
John
Project MVP