How to add Work for tasks having a certain name

[ppadmana]

Hi,

I have 100 or so tasks in my project plan. I want my plan to reflect
the total work only for those tasks that have the name "Contingency".
How can I do this?

Thanks
Prasanna Padmanabhan

 

[John]

Hi,

I have 100 or so tasks in my project plan. I want my plan to reflect
the total work only for those tasks that have the name "Contingency".
How can I do this?

Thanks
Prasanna Padmanabhan

Prasanna,
The normal Work field will always show total work for all tasks that
have an assigned resource. In order to limit the total work to a select
group of tasks, there are two choices.

First, you could use the grouping feature (Project/Group By/Customize
Group By). Do the following:
1. Designate a spare text field to identify the contingency tasks
2. Group by that text field. The group summary will show the total work
hours for that group only.
3. Filter the grouped set to only show those tasks with "contingency" in
the spare text field

Another method would be to customize a spare number field with a
formula. In the formula, test the Task Name field for the string,
"contingency". If that string is found, populate the custom field with
the value in the Work field. Then rollup up the sum to summary lines.
For example, the following formula will work for the Number2 field.
IIf(instr(1,[Name],"contin")>0,[Work]/60,0)

Hope this helps.
John
Project MVP

 

[salgud]

Hi,

I have 100 or so tasks in my project plan. I want my plan to reflect
the total work only for those tasks that have the name "Contingency".
How can I do this?

Thanks
Prasanna Padmanabhan

Your total plan will always reflect the total work assigned to all of the
tasks. If you want to see the total work just for tasks called
"Contingency", you can filter for them and create a report that sums just
those tasks.

Hope this helps in your world.

 

[ppadmana]

Thank you John. Your idea works great!

Hi,

I have 100 or so tasks in myprojectplan. I want my plan to reflect
the total work only for those tasks that have the name "Contingency".
How can I do this?

Thanks
PrasannaPadmanabhan

Prasanna,
The normal Work field will always show total work for all tasks that
have an assigned resource. In order to limit the total work to a select
group of tasks, there are two choices.

First, you could use the grouping feature (Project/Group By/Customize
Group By). Do the following:
1. Designate a spare text field to identify the contingency tasks
2. Group by that text field. The group summary will show the total work
hours for that group only.
3. Filter the grouped set to only show those tasks with "contingency" in
the spare text field

Another method would be to customize a spare number field with a
formula. In the formula, test the Task Name field for the string,
"contingency". If that string is found, populate the custom field with
the value in the Work field. Then rollup up the sum to summary lines.
For example, the following formula will work for the Number2 field.
IIf(instr(1,[Name],"contin")>0,[Work]/60,0)

Hope this helps.
JohnProjectMVP

 

[John]

Thank you John. Your idea works great!

Prasanna,
You're welcome and thanks for the feedback.
John

Hi,

I have 100 or so tasks in myprojectplan. I want my plan to reflect
the total work only for those tasks that have the name "Contingency".
How can I do this?

Thanks
PrasannaPadmanabhan

Prasanna,
The normal Work field will always show total work for all tasks that
have an assigned resource. In order to limit the total work to a select
group of tasks, there are two choices.

First, you could use the grouping feature (Project/Group By/Customize
Group By). Do the following:
1. Designate a spare text field to identify the contingency tasks
2. Group by that text field. The group summary will show the total work
hours for that group only.
3. Filter the grouped set to only show those tasks with "contingency" in
the spare text field

Another method would be to customize a spare number field with a
formula. In the formula, test the Task Name field for the string,
"contingency". If that string is found, populate the custom field with
the value in the Work field. Then rollup up the sum to summary lines.
For example, the following formula will work for the Number2 field.
IIf(instr(1,[Name],"contin")>0,[Work]/60,0)

Hope this helps.
JohnProjectMVP