Customise Group By
Featured Partner
Top Posters
jeoffrey reyes
15 posts
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Our Partners
Hi Bryan
Also, you could use the customised fields in MS Project.
Add Columns Text1, Text2 & Text 3 (Text 2 & 3 will have your data)
Right Click on Column Heading Text1
Select Customise Fields
Click Formula
Enter this formula
([Text2] & " - " & [Text3])
Click OK
Click OK
This will give you the concatenation like excell
Regards
Colin
HI Bryan
If you are going to put digits in front of the text make sure you use leading zeroes - 001 002 003 etc otherwise the sort function wont work.
If you are minded to add code text or numbers to your descriptions you can avoid a lot of typing by using the concatenation fetaure in excell.
Copy paste your description column into row a.
Type the leading text into row b
In row c place the formular +b1&a1 and copy down the row.
Copy paste row c back to your description column.
Best regards
Mike Testro
Bryan,
It doestn work the way you for. It could be only acsending or descending.
But I think it doestn matter what is the sequence for B,A,D,C, in your exaple if B,A,D,C UNDER ONE TITLE "PHASE"
However,if you keen to get it, just put some digits in front of your descriptions. it would be like (1)ENGINEERING
(2)PROCUREMENT...etc
good luck.
ramil
That absolutly works for my current situation, but I was trying to avoid having to do that.
Using the group by prefix gets it to group on the value list values correctly, but dosnt print the description and it dosnt appear you have any option to select wether you sort by row number, value or description.
You also have to go to great lengths to get the value list in the correct sequence, it seems the only place this is used is when you use the drop box in entering data.
seems there is something missing. Or I am missing something.
So now, to get Phase grouped, I have a value list of A, B, C, D etc with descriptions of "A - Engineering", B - Procurement", "C - Construction" etc. I have to match the prefix to group and sort by with the sequence I want it to appear. in the value list entry screen, you have to place the descriptions in the sequence you want them to appear by, for example I could place them in B, A, D, C sequence.
Seems redundant to have to repeat that sequence with text or numbers in a prefix and have to reconcile that sequence and now explain to schedule report recipients why you have these codes and what they all mean.
An occasion you may want the code in the value list to appear in a different sequence than alpha numeric is when your company has an established list of codes, that is not in alphanumeric sequence that you need to use on your project.
How about just including the code (Value) as part of the description?
AAAXX - rest of description text