Lock task ID to specific task

[ccgsuper]

Is it possible to lock the generated task ID to it's respective task so that
it does not change even if a previous task is deleted? I thought if I
unlocked the ID column the assigned numbers would not change, but they still
renumbered all tasks beyond the deleted task.

 

[Mike Glen]

Hi ccgsuper ,

Welcome to this Microsoft Project newsgroup

No, it is not possible. However, Project does assign an UniqueID to every
task which doesn't change. You can use that firel. Another option is to
copy the ID column to an empty field like Text1 and use that, as Project
will not change those numbers.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[ccgsuper]

That's kinda what I figured. Will probably create the additional column as
the work around.
Thanks for the help.
ccgsuper

 

[meg99]

That's kinda what I figured.  Will probably create the additional column as
the work around.
Thanks for the help.
ccgsuper











- Show quoted text -

ccgsuper,
I don't know what you are using the ID for, but you might consider the
Unique ID. In our Integrated Master Schedule, I track certain tasks
(major reviews, tests, product deliveries etc) from supplier/vendor
schedules. In order to ensure that I am tracking the correct task, I
use their Unique ID to update my Master Schedule.

meg99

 

[Mike Glen]

Sorry, that should read "You can use that field"! I was surprised the
spellchecker didn't pick up my bit of finger trouble


Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[ccgsuper]

To make a long story short, the data from the schedule is exported (actually,
cut and pasted) to an excel file for further analysis. The key is that the
lookups used in the excel file look for that ID. If anything changes in the
Project file (i.e. move, delete a task, etc.), the the entire lookup routine
will be off. The unique ID column would work fine if it were included in the
cut and paste operation.

Thanks for the input.

 

[Mike Glen]

You're welcome, So are you going to onclude the IniqueID field?

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[meg99]

To make a long story short, the data from the schedule is exported (actually,
cut and pasted) to an excel file for further analysis.  The key is thatthe
lookups used in the excel file look for that ID.  If anything changes in the
Project file (i.e. move, delete a task, etc.), the the entire lookup routine
will be off.  The unique ID column would work fine if it were included in the
cut and paste operation.

Thanks for the input.







- Show quoted text -

A solution - Export the Unique ID. If the lookup produces #NA, you
know that the task was deleted. If you get lots of #NAs you know that
probably it is a new project (sometimes people will start over with a
new project, cut and paste from one to another, etc and save the new
project with the same title/name).

meg99