Group By

[Marylou]

Can you tell me if it is possible to remove the "Text1:" in the description
of the task when you group by text1. I want to use group for presentation and
do not want this to show. thank you

 

[Dale Howard [MVP]]

Marylou --

Click Tools - Customize - Fields. Select the Text1 field and then click the
Rename button. Enter a name for the field and click the OK button. Reapply
the Group and you should now see the new name you entered for the Text1
field. Hope this helps.

 

[Dean C]

As an alternative, move the contents of text1 to an outline code field. The
summary bar will be the values.

 

[Marylou]

Good morning Dale, thank you. I know how to do this, however it is the title
of the file that I need to NOT display
example: Group by Text1 produces Text1: or if field renamed: Customer1: etc

I need to only show what is AFTER the : on the report so it appears that
there is no grouping. Hope this is clear.

Is there a formula I can write to show only what is after the MSP group
name, ie:. “IIf([Summary]=Yes,Space(([Outline Level]-1)*5) &
right([Name],len([Name])-instr(1,[Name],"_")-2),Space(15) & [Name]â€

Too bad this site does not allow us to show you a picture show my question
is clear.

 

[Marylou]

THANK YOU Dean. I was trying to complicate things. It works perfectly. I
knew this also, but could not see the forest for the trees.