Is there a way to put the priority column in a usage view?

M

Michelle Moulliet

I'd like to be able to see the priority column in the resource and task usage
views. Is there any way to put it in? Thanks.
 
J

John

Michelle Moulliet said:
I'd like to be able to see the priority column in the resource and task usage
views. Is there any way to put it in? Thanks.

Michelle,
Sure, but perhaps you should go to our MVP website at:
http://www.mvps.org/project/faqs.htm
and take a look at FAQ 51 - Data Types: Task, Resource and Assignment.

John
Project MVP
 
M

Michelle Moulliet

John, thanks for your help, but I think I was not specific enough in my
question (silly me!). So, here goes giving it another shot. :)

I'd like to see priority in the resource usage view and I understand that
the resource usage view is a combination view. I also understand that
priority is task information and that I can't insert that column into the
resource usage view (I tried despite my gut feeling telling me the answer was
no).

Nevertheless, it would be ideal for me to be able to have that info in the
resource usage view. I'd like to be able to adjust priorities and resource
assignments in the same view while seeing the assignments grouped by
resources and sorted by start date.

Any ideas on how to get the field in? If not, I'm thinking maybe a combined
view with the gantt and resource usage will show me all of the info I need to
assign resources and priorities.

Thanks again.
 
J

John

Michelle Moulliet said:
John, thanks for your help, but I think I was not specific enough in my
question (silly me!). So, here goes giving it another shot. :)

I'd like to see priority in the resource usage view and I understand that
the resource usage view is a combination view. I also understand that
priority is task information and that I can't insert that column into the
resource usage view (I tried despite my gut feeling telling me the answer was
no).

Nevertheless, it would be ideal for me to be able to have that info in the
resource usage view. I'd like to be able to adjust priorities and resource
assignments in the same view while seeing the assignments grouped by
resources and sorted by start date.

Any ideas on how to get the field in? If not, I'm thinking maybe a combined
view with the gantt and resource usage will show me all of the info I need to
assign resources and priorities.

Thanks again.

Michelle,
Well, I'm glad you read the FAQ. I hope you also read the related FAQ 37
which actually tells you how you can put the Priority field info into
the Resource Usage view. It won't be pure but since "assignment" rows in
the Resource Usage view are analogous to Tasks, (note I didn't say
equal), the Task Priority info could be put into a spare assignment text
field (e.g. Assignment Text1). Please note however that doing so will
only put an independent copy of the priority information into the
Resource Usage view so changing it in that view will have no effect on
the actual Priority field - probably not what you really wanted.

Your last paragraph is your best bet. Why not simply do a split screen
with the Gantt Chart view in the top pane and the Resource Usage view in
the bottom pane.

John
Project MVP
 
J

Jan De Messemaeker

Hi Michelle,

Install and run the following Macro:

Sub CopyPriority()
dim Job a task
dim Whodunit as assignment

for each job in activeproject.tasks
if not job is nothing then
job.number1=job.priority
for each whodunit in job.assignments
whodunit.number1=job.priority
next whodunit
end if
next job
end sub

Of course, you have to rerun this when the priorities or the assignments
change.
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top