Hi,
I am using ms project daily and often use unique ID for my tasks which is good.
But this way it only creates a ID number, but now I also want to add a letter.
Example: KF1000
Is there possible to create this with a type of formula in a text field?
I would also like that when I create a new task it should generate automatically next step in the chain
Example: KF1010
New task KF1020
And so on
Is this possible?
I hope you guys understand my question
Thanks
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
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 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