Calculated Field won't calculate

[Steve Scott]

I have been using a great formula for a year or so now which combines a value
that I store in the Title field of the File Properties and the Unique ID.
This gives me a unique Milestone ID across all projects in my consolidated
plan.

On occasion however, I have noticed that if I change the value in the Title
field it does not update the calculated field I have set up. If I then blank
out the Title field the caluclated field does calculate ie the result is just
the Unique ID. When I then go and add a value back into the Title field it
does not update the calculated field!?

Does anyone know why this is? I am using a combination of MSP 2000, 2002 &
2003 files all of which have autocalc enabled.

 

[Jack Dahlgren]

Steve,

There are a couple of other occasions when the "title" doesn't seem to
update as expected. I would guess that this is a similar bug. My advice would
be to use a macro to do this rather than a calculated field.

-Jack
http://zo-d.com/blog