Two Independent Resource Lists in One Project Plan

[rcatalano001]

I was reviewing the thread that was posted on 10/9/06 (thanks Shelley & John)
and tried to leverage the learning from that discussion, but I keep coming up
short.

Here is my scenario:

I am trying to create a workplan where I can independently filter on
resource name and plant type for my industry.

As I have the ability to assign multiple resources to a task via the
resource name functionality (with a drop down list of available resources), I
independently need to assign multiple plant types to a task via a field that
has a drop down list (like resource name) and the ability to select multiple
plants from the list.

Using the value list does not seem to work because it only allows you to
select one and only one value.

I tried using the formula approach, but it seems to only work in reference
to the resource field and not independent of the resource field.

Does anyone have any other creative suggestions??

I appreciate your time.

 

[Jim Aksel]

A Plant is a resource and could be added to the resource sheet, perhaps at no
cost.
You can assign multiple (human) and mulitple plant type resources to a
specific task.

Then, using a custom filter you can setup the way you want. The custom
filtering allows for AND and OR type filtering which should take where you
need to go. Additionally, one of the filter criteria is "contains" so if you
have a long resource string you can look to see if it "contains" something
like Plant#1, etc.

Maybe I missed something, please let us know if you need more help.

If you more specific questions, please post back and let's see what else we
can offer you. If you found my post helpful, you may want to rate it.

 

[rcatalano001]

Thanks for the reply Jim.

I need to have two separate columns for each task, one for resources, the
other for plant type and I need to be able to filter them independently.

 

[Jim Aksel]

I see now, sorry for the misunderstanding. I think you may need to go down
the VBA road and post your question on the Developer Forum. You may want to
try Rod Gill's site: http://www.projectvbabook.com/

If the number of plant types is small (say 4), then you could brute force it
by having a value list for every possible combination of plant.

I think a VBA solution is your best approach at this time. Remember, it is
software - it's not allowed to win.

 

[rcatalano001]

Thanks Jim,

Yes I am using the brute force approach for the time being. I was hoping
there was a simple elegant solution out there that I was just not seeing.

Thanks for your time and attention to this matter.

Rick