Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to specify the order for codes in layouts in MPP?

3 replies [Last post]
Wed, 2007-12-26 08:37
David Moses
User offline. Last seen 11 years 24 weeks ago. Offline
Joined: 20 Oct 2004
Posts: 122
Groups: Petro-Chem / Oil & Gas
Hi There,

In P3 Help File:

Define Activity Codes and Values

Article #5) to specify the order for codes in layouts or reports, enter a number from 1 to 254 in the order column. If this field is blank, P3 sorts the values in alphanumeric order, considering blanks first, then numbers and letters.

This is very useful I think.

But could you tell me, how can we sort the codes in layouts in Microsoft Project (version 2003) like P3? (as explained above)

Regards
Top

Replies

Fri, 2008-01-11 09:23
#1
James Barnes
User offline. Last seen 1 year 5 weeks ago. Offline
Joined: 6 Sep 2007
Posts: 243
Groups: Petro-Chem / Oil & Gas
David, to the best of my knowledge, MSP cannot manage activity code sorting to anything like the level of sophistication that P3 can.

My advice; use P3
Top
Fri, 2008-01-11 05:23
#2
David Moses
User offline. Last seen 11 years 24 weeks ago. Offline
Joined: 20 Oct 2004
Posts: 122
Groups: Petro-Chem / Oil & Gas
First of all thank you Benjamin.

Any other comments?

Regards,
Top
Wed, 2008-01-02 18:42
#3
Benjamin Mora
User offline. Last seen 10 years 41 weeks ago. Offline
Joined: 19 Oct 2007
Posts: 66
Groups: None
MS Project will not do exactly what you are refering to, but and I am not sure if this helps, but all you have to do is [Insert] ([Right Click] the column header & [Left Click] "Insert Column", then select the applicable column) the desired column in the schedule, then [Right Click] on the column\activity code column that you want to create a picklist for. Select [Customize Field] and then [Left Click], under "Custom Attributes", [Value List]. [Key In] the values. You can manipulate the order by [Selecting] the value with your cursor and the [Left Clicking] the [Up Arrow] button or the [Down Arrow] button to change the order of a particular value; this can be found on the right-hand side of the dialogue box. Once that is complete you [Toggle] the "Radio Buttons" under "Display Order for Dropdown List" to sort by "Row number", "Ascending", or "Descending". [Left Click] "OK" when you have the desired results.
Top