Proj 2003 Custom Fields

[rick_schneegold]

I'm trying to determine the code behind the Status field.
I would expect to see some kind of a filter or customer
field formula. I would like to modify....
OR
Create my own customer field.
I want to test for multiple conditions on each task and
provide a "value" in the field similar to the Status field.
Example: if the finish date is greater than the baseline
finish then x= "off schedule". This is a simple case but
there are multiple fields and conditions that would be
inthe arguments before setting the field value. I tried
to use the IIf but couldn't get it to work.
Any ideas?
I'm not a VBA person.

 

[JackD]

I'm trying to determine the code behind the Status field.
I would expect to see some kind of a filter or customer
field formula. I would like to modify....
OR
Create my own customer field.
I want to test for multiple conditions on each task and
provide a "value" in the field similar to the Status field.
Example: if the finish date is greater than the baseline
finish then x= "off schedule". This is a simple case but
there are multiple fields and conditions that would be
inthe arguments before setting the field value. I tried
to use the IIf but couldn't get it to work.
Any ideas?
I'm not a VBA person.

Here is what Project Help says about the status field:
==========
Description The Status field indicates the current status of a task,
specifying whether the task is Complete, On Schedule, Late, or a Future
Task.
How Calculated If the task is 100% complete, then Microsoft Project sets
the Status field to Complete. If the task start date is greater than the
status date, then the Status field contains Future Task. If timephased
cumulative percent complete is spread to at least the day before the status
date, then the Status field contains On Schedule. If the timephased
cumulative percent complete does not reach midnight on the day before the
status date, then the Status field contains Late.
===========
It is calculated internally, so there is no "code" that you can see for it,
and thus you can't modify the code for the status field. However, given the
algorithm stated above you could replicate it.

To answer the rest of your question we need more information about what you
actually want to do and what you did that did not work. It should be easy to
tell you why it is not working and to give you an idea of how to make it
work. Without a specific example it is impossible to tell what you are doing
wrong.

-Jack