P
pm15127
I have added a the column called "status".
How do I know what formula MS project is using for this column?
thank
How do I know what formula MS project is using for this column?
thank
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John
pm15127 said:I have added a the column called "status".
How do I know what formula MS project is using for this column?
thanks
pm15127,
Perhaps the best way to find out about any of Project's fields is to add
that field as a column to your current view and then hover your mouse
over the column heading. In a moment or two, a popup will appear
allowing you to select the help topic on that field.
Try that and see if it provides the information you need.
John
Project MVP
P
pm15127
it does describe what the column is about but does not show what formul
is used
is used
J
John
pm15127 said:it does describe what the column is about but does not show what formula
is used.
pm15127,
I'm not sure what more you want that isn't described by the Status field
help topic. It tells how each type of status is determined. Complete and
Future status are simple "If" statements based on the Percent Complete
and Start and Status Date fields respectively. The On Schedule and Late
status are "calculated" using If-Then-Else logic based on timephased
data.
Complete and Future can be "calculated" with an "If" statement in a
custom field, the latter two cannot since timescale data is not
available for use in formulas in custom fields. That requires VBA.
John
Project MVP
J
JulieS
John said:pm15127,
I'm not sure what more you want that isn't described by the Status
field
help topic. It tells how each type of status is determined.
Complete and
Future status are simple "If" statements based on the Percent
Complete
and Start and Status Date fields respectively. The On Schedule and
Late
status are "calculated" using If-Then-Else logic based on
timephased
data.
Complete and Future can be "calculated" with an "If" statement in
a
custom field, the latter two cannot since timescale data is not
available for use in formulas in custom fields. That requires VBA.
John
Project MVP
Perhaps PM15127 is referring to this:
Complete = 0
On Schedule = 1
Late = 2
Future Task = 3
If used in a custom field, you need to refer to the number values,
not the text "Complete", "On Schedule" etc.
I hope this helps. Let us know how you get along.
Julie
Project MVP
Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project