Dynamic task names

[Ric Deez]

Hi there,

Is there a way of defining a task name so that it is dependent on other
custom and standard fields that exist in the project plan? Example:

Name Task Name Text30 Text29
Wangaratta Tier 2 POP Commissioning Wangaratta 3
- Installation of PSTN lines ( x 3) Wangaratta 3
- Task 2 Wangaratta 3
- Task 3 Wangaratta 3

<<POPx> Tier 2 POP Commissioning <<POPx>>
- Installation of PSTN lines ( x <<PSTN_line_no>> <<POPx>>
<<PSTN_line_no>>
- Task 2
- Task 3

is it possible to have task names defined as = [name] & " " & [text30] for
one ROW and defined as = [name] & "( x " & [text31] & ")" for another ROW?
I know about doing the customise fields and formula to change all of the
fields on a specific COLUMN but I don't know how to define it on a row by
row basis. Is this possible?

Regards,

R.

 

[Jan De Messemaeker]

Hi Ric,

With VBA Macro's and coding it is definitely possible.
With formulae not only do you have the same formulat for all rows, but you
cna only have a formula in a custom field (and Name isn't one!)

Greetings

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620