Multiline field for text display in rollup summary

[Carlos N]

I have a rollup summary task which displays the milestones in the
rollup. For each milestone I can assign a "top" label in the rollup
that includes a particular field, say the name. However, I would like
this text label to include both the field and the start date. Yes, I
can display one on the top and the other on the bottom, but I'm already
using the bottom for something else.

Is there a way to have a particular field label display multiple lines?
I tired mucking around with a custom field using the "chr" function,
but any ASCII code less than 32 results in an error.

Thanks!
Carlos

 

[John]

I have a rollup summary task which displays the milestones in the
rollup. For each milestone I can assign a "top" label in the rollup
that includes a particular field, say the name. However, I would like
this text label to include both the field and the start date. Yes, I
can display one on the top and the other on the bottom, but I'm already
using the bottom for something else.

Is there a way to have a particular field label display multiple lines?
I tired mucking around with a custom field using the "chr" function,
but any ASCII code less than 32 results in an error.

Thanks!
Carlos

Carlos,
Try using a spare text field (e.g. Task Text1) with the following
"formula". It will produce a concatenated string similar to:
task a - 2/7/2006
Text1=[Name] & "-" & mid([Start],1,instr(1,[Start]," ")-1)

Hope this helps.
John
Project MVP

 

[Carlos N]

I have a rollup summary task which displays the milestones in the
rollup. For each milestone I can assign a "top" label in the rollup
that includes a particular field, say the name. However, I would like
this text label to include both the field and the start date. Yes, I
can display one on the top and the other on the bottom, but I'm already
using the bottom for something else.

Is there a way to have a particular field label display multiple lines?
I tired mucking around with a custom field using the "chr" function,
but any ASCII code less than 32 results in an error.

Try using a spare text field (e.g. Task Text1) with the following
"formula". It will produce a concatenated string similar to:
task a - 2/7/2006
Text1=[Name] & "-" & mid([Start],1,instr(1,[Start]," ")-1)

I tried something similar (used Format instead of Mid, but same
difference). The problem is that the text label gets to be quite long
and starts overlapping the next milestone. That's why I was looking for
something that split the label into two lines. It's looking like that
is not possible.

What you're suggesting
My Task - 02/07/2006 (OK, but not great)

What I'd like (ideally):
My task
02/07/2006

 

[John]

I have a rollup summary task which displays the milestones in the
rollup. For each milestone I can assign a "top" label in the rollup
that includes a particular field, say the name. However, I would like
this text label to include both the field and the start date. Yes, I
can display one on the top and the other on the bottom, but I'm already
using the bottom for something else.

Is there a way to have a particular field label display multiple lines?
I tired mucking around with a custom field using the "chr" function,
but any ASCII code less than 32 results in an error.

Try using a spare text field (e.g. Task Text1) with the following
"formula". It will produce a concatenated string similar to:
task a - 2/7/2006
Text1=[Name] & "-" & mid([Start],1,instr(1,[Start]," ")-1)

I tried something similar (used Format instead of Mid, but same
difference). The problem is that the text label gets to be quite long
and starts overlapping the next milestone. That's why I was looking for
something that split the label into two lines. It's looking like that
is not possible.

What you're suggesting
My Task - 02/07/2006 (OK, but not great)

What I'd like (ideally):
My task
02/07/2006

Carlos,
Well I was going to caution you about the long text problem but decided
not to. Unfortunately Gantt bar labels can't be multi-line, and probably
for good reason - things could get cluttered in a hurry.

I suggest you leave off the date - that's what the timescale at the top
is for! The task name may still be too long and the only solution for
that is to abbreviate (e.g. create an abbreviated version of the task
name in a spare field and then display the spare field).

John
Project MVP