ID for activity

Hi Dan

 

I can get the prefix but not the automatic generation (as in P3) I use MS Project 2003

First I added 3 new fields Text 1 & Text 2

Changes the tiltle of Text 1 to New unique ID

Text 2 will st the KF identifier

I then Right clicked on Text 1 and selected Customized Fields (make sure Text 1 is selected)

Then Select Formula

Then Type

([Text2] & "-" & [Unique ID])

Click OK

(Create a new Table)

View - Tables - More Tables

Click Copy

Then Click Edit

Delete old ID & replace with Text 1 (tick lock 1st column)

 

Hope this helps

Colin

 

Using Hammer’s Rule, “if won’t fit hit it with a hammer until it fits”.

Try concatenating by first converting number fields to text using a custom text field and a formula. [Custom Text Field]= [Number Field]. Then concatenate Text Fields using a formula with the text fields and + sign in between. You can enter your letters on a text field, a formula or any other way it occurs to you. Seems like the trick is converting number fields into text fields and then use these new fields ito concatenate on a separate custom text field.

 

 

 

Hi Colin and Rafael,

 

Thank you for this lovely information.

 

This helps me a lot.

 

It seems that there is no limit to knowledge and good ideas in this community

 

Regards

 

Dan