Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

ID for activity

3 replies [Last post]
Fri, 2010-09-24 13:11
Dan Mårtensson
User offline. Last seen 12 years 26 weeks ago. Offline
Joined: 4 Feb 2010
Posts: 59
Groups: Civil Engineering

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

Top

Replies

Thu, 2010-09-30 09:54
#1
Dan Mårtensson
User offline. Last seen 12 years 26 weeks ago. Offline
Joined: 4 Feb 2010
Posts: 59
Groups: Civil Engineering

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

Top
Tue, 2010-09-28 13:43
#2
Rafael Davila
User offline. Last seen 8 weeks 4 days ago. Offline
Joined: 1 Mar 2004
Posts: 5241
Groups: Spider Project Team

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.

 

Concatenate 3

 

MS Concatenate

 

Concatenate 2

Top
Tue, 2010-09-28 09:58
#3
Colin Blair
User offline. Last seen 45 weeks 2 days ago. Offline
Joined: 22 Apr 2004
Posts: 29
Groups: None

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

 

Top