Robert,
Once you get output I think you will see that you want to reverse the
current date and the finish date in your formula. Once you get it working
it will be easy for you to determine which way to go with that.
The [Status] field is a task level field and therefore will not be available
for use in Project Center views. But I also checked the Project views in
PWA and this field is not available for use there either. The field is only
available in Project Professional to use. If you want to create a task
custom field that is based on this field then you can use this formula:
IIf([Status]=0,"Completed",IIf([Status]=1,"On
Schedule",IIf([Status]=2,"Late","Future Task")))
I am not sure what you are doing wrong with the graphical indicators but
what I would first try is to work solely in Project Professional and try to
get your task custom field to work at the local level and without graphical
indicators. Once you start getting values back in the Text1 field for
example, then try to add the graphical indicators, BTW you do not need to
add quotes around the text value, just type the value as it is.
Once you get the local field working like you want you can convert it into
an enterprise field by clicking the "Add Field To Enterprise..." button.
Then you will be able to add this custom enterprise field to your Project
views under PWA>Manage Views.
Jonathan
Robert Juarez said:
In response to your post:
a) I still think mine makes sense since I'm trying to display tasks where
the finish date is earlier than the current date (ie - current date is
greater), but I tried reversing it for the sake of testing, still no
output
once I took b) below into consideration.
b) You're right...I was using a custom date field. Since it won't let you
change it I created a new field with an Entity of "Task" and a Type of
"Text". I tried my formula my way and your way and I still get no output
for
that field when I add it to any task view. The graphical indicators part
still gives me an invalid message as well. I used "equals" and a value or
"red" without quote marks...is that correct or since it is text do I need
quotes? I tried both and tried using contains but still get the same
message.
c) I opened the project schedule in MS Project Professional 2K7 from the
PWA
window, hit F9, saved and published, and closed it but still no success in
PWA view.
d) I can't find a task field called status. I assume I should find it
when
I go to modify a Project Center view under "Available fields"? I don't
see
it there. If I should be looking elsewhere please let me know.
I really would like to get this working and it seems like it should be
relatively simple but I'm running into some hiccups.
Thanks,
Robert
Jonathan Sofer said:
a) Your formula has a mistake in it I believe. The first condition
should
be reversed i.e. [Current Date]<[Finish] rather than [Finish]<[Current
Date]
b) Did you use a custom "Text" field to define your formula in? The
results
of your formula yields text so the field type has to be text. The fact
that
you get an error when trying to define your graphical indicators leads me
to
believe you are using some other type of field like "Date" or "Duration"
maybe?
c) Did you hit F9 in your schedule to force a calculation refresh? This
sometimes needs to be done to force the formula to calculate
d) There is an existing out of the box task field called "Status" that
will
generate a similar results if you want to look at that instead.
e) You might want to consider a different formula result if the task is
100%
and finishes in the future.
I'm trying to create a view that shows overdue tasks and am having some
trouble. I went into enterprise custom fields and tried to create a
new
Task
Date field with the following formula :IIf([Finish]<[Current Date] And
[%
Complete]<100,"red","green"). Now I would expect it to populate that
field
with either "red" or "green" depending on if it meets the criteria.
Furthermore I would like to use graphical indicators to show red or
green
stoplights. However, I cannot get this formula to work - When I add
the
new
field to a view that displays the data values it is blank for all tasks
and
when I try to setup the graphical indicator it keeps telling me they
are
not
valid. What am I doing wrong?
.