Custom field formulas and inserted projects

[LeslieF]

Hello,

I have a master project into which I've inserted 6 projects. Each of these
inserted projects has custom enterprise project fields, one of which is the
product format (CD, book, etc).

In the master project, I've created a custom field with the following
formula:
[Name]+" ("+([Enterprise Project Text2])+")". When I apply it, nothing shows
up. I'm trying to produce a combination of the subproject name with it's
product type followed in parentheses, which I want to display on the Gantt
chart.

I've used this formula in another master file (though using a custom text
rather than an enterprise project test) and it works just fine.

Is it my use of the enterprise project text or something else? Any help
would be greatly appreciated.

Regards...LeslieF

 

[JackD]

A couple of things.
1) Make sure that your custom field is set to use the formula for summary
tasks.
2) When concatenating it is better to use an & instead of a +.

 

[LeslieF]

Ah, so simple and obvious! I hadn't set it to use the formula for summary
tasks. Thanks! I'll also amend to use the "&".

I appreciate the help! ...L

A couple of things.
1) Make sure that your custom field is set to use the formula for summary
tasks.
2) When concatenating it is better to use an & instead of a +.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

Hello,

I have a master project into which I've inserted 6 projects. Each of these
inserted projects has custom enterprise project fields, one of which is the
product format (CD, book, etc).

In the master project, I've created a custom field with the following
formula:
[Name]+" ("+([Enterprise Project Text2])+")". When I apply it, nothing shows
up. I'm trying to produce a combination of the subproject name with it's
product type followed in parentheses, which I want to display on the Gantt
chart.

I've used this formula in another master file (though using a custom text
rather than an enterprise project test) and it works just fine.

Is it my use of the enterprise project text or something else? Any help
would be greatly appreciated.

Regards...LeslieF