Resource names in a custom field

[hisbadbanana]

I am using the Resource field that is populated from the Resource sheet.

However, I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well.

It's not available in the Import Values option
It's not available as the formula
I can't even copy and paste them in (unless I do it one by one)


Any ideas?


-HisBad

 

[PDQBach]

There are some items which are unclear.

"I am using the Resource field that is populated from the Resource sheet."

Which view are you using?
Which field (there are several) are you referring to?

"I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well."

The field "Text1" in a task row is not the same as "Text1" in a Resource row.

Which version of Project are you using?

 

[hisbadbanana]

sorry for the ambiguity...

version 2003 standard.

I populated the resource sheet using the wizard that grabs the names from Outlook.

So when I am in the Gantt cgart view I use the Resource Names column to add a resource to a task.

I would also like to have "Text1" (in the task row) to pull down so I can choose a Resource Name for the Text1 field.

hope that makes sense.

-Hisbad

 

[PDQBach]

Makes perfect sense.

There's no easy way to do what you want. The issue is populating the table of values for the Text1 column.

You'll have to choose to populate it manually one row at a time (sorry) or you could try writing some vba code to do it.

The following also won't work:

View | Resource sheet
Insert the Text10 column
Copy the Resource Name column
Paste it into the Text10 column

View | Gantt chart
RightMouseButton on the Text1 column header
Choose "Customize"
You'll get a popup "Customize Fields"
Click on Value List button
You'll get a popup "Value List for Text1".

There's a button at the bottom that says "import value list". This imports the values from an *existing* value list -- but doesn't let you create the list using existing values.

Why is this a problem? It means that you can't click on the "import value list" button and then import from the values from the Resources.Text10 field that you just created.

Best I can suggest:

View | Gantt
Window | New Window
view: Resource Sheet
Window | Arrange all

RightMouseButton on Gantt view Text1 column header
Click Customize
Click Value list button
Manually enter the text you want.

That way you'll have both the Gantt View and the Resource sheet view displayed on the screen simultaneously and you'll have quick access to the information that you have to manually enter.

There might be some VBA code to do this, but I'm kinda swamped now and am not able to find the time to develop it.