The sandbox I use has "Calculation Mode" set to "Automatic", so I
didn't
think I had to do anything! I will remember "F9", now!
That did put the fields I had played with to what I expected,
although
not to what I want. I will re-try some past efforts.
Thanks for all the patience! Have we set the record for the longest
series of posts? :>)
:
Jackson T. Cole --
After you create an enterprise field containing a formula, you need to
open
each project and press the F9 function key to recalculate the project.
Since the formula simply reads the Status Date field, you will need to
use
an IIF statement in your formula such as IIF([Status Date] =
ProjDateValue("NA"), truevalue, falsevalue) to trap for the "NA" value
if
someone has not set a Status Date value. Hope this helps.
message
FYI, I tried that formula you gave below in BOTH an Enterprise
Date
and
an
Enterpise Text field, and all I can get displayed in Project
Information
is
"#ERROR", when I should get the second literal string. And yes, I do
exit
and
restart MS Project everytime I change the Enterprise Global!
A more generic question: How do you use the formulas to display
dates
from the various Project Date fields? Surely there is a way? Is
there a
document somewhere that explains these formulas and how to use them?
Finally, Status Date as displayed in "Project Information" is
changed
if
you "Update Entire Project" in the Tracking Tool. It is NOT changed
when
individual blocks of tasks are updated. It can be forced to be ANY
date
in
the Project Information form, so my intent for using it as an QA
enforcement
tool is probably moot!
I still want to learn more about these formulas, though.
:
Jackson T. Cole --
A workaround would be to create a custom enterprise Project date
field
that
includes the Status Date formula you mention. You would need to
account
for
potential "NA" values, however, in the formula. Since I never set
the
Status Date field in any of my projects, but regularly update,
save,
and
publish them, I would look like a "loafer" in your organization.
Hope
this
helps.
message
Not even using a custom date field and a formula similar to
the
one
below, but not using literal strings?
PMs can make all those other values look good by opening and
saving
the
project once a day! Status Date is only set when you use the
tracking
tool,
right?
Ever hopeful .... :>)
:
JC --
There's no way to add the Status Date field to Project Center
views.
A
far
more clever approach, however, might be to create a new Project
Center
view
called "Update Status" or something like that and then include
the
following
fields:
Project Name
Last Modified
Last Published
Last Saved By
From those three fields, you should easily be able to show your
management
staff how many PM's are not using the tool as often as required.
Just
a
thought. Hope this helps.
in
message
Is there a way to get the Project Status Date published? I
can't
find
anything in the list of fields on PWA that resembles Project
Status
Date,
and
I would really like to show manaement how updates are being
neglected!
JC
:
Carl --
You are more than welcome, my friend!
"Carla Alvarado" <
[email protected]>
wrote
in
message
Yes!!!!!
Thanks..... It's Status Date.
Regards,
Carla
:
Carla --
I assume that when you say "State Date" you actually mean
Status
Date.
Here's how to write the formula in question:
IIf([Status Date]=ProjDateValue("NA"),"There is no Status
Date",
"There
is a
Status Date")
Hope this helps.
"Carla Alvarado" <
[email protected]>
wrote
in
message
Please...
I need to create a formula in an Enterprise Custom Field
,
and
I
don't
know
how I should indicate if the State Date is empty..
Is this sentence correct: ????
Iff ([State Date]=NULL,'THERE IS NOT a State
Date','THERE
IS a
State
Date')
Please Help!!!
