Formula custom field.

[Nik003]

Project Server 2007

I am trying to create a custom field that determines if a project is
baselined or not. I'll be using this later in a check for other fields. I
have tryed this:

IIf([Baseline Finish]>50000,"False","True")

as well as other cobinations I have found on the web:


IIf([Baseline Finish]=ProjDateValue("NA"), “No Baseline Set†, “Baseline Setâ€)
IIf(ProjDateValue([Baseline Finish])=4294967295, “Trueâ€, “Falseâ€)

But for some really weird reason I get only #ERROR returned. This does not
make much sense to me.

Anybody?

 

[Susan Cobb]

IIf(ProjDateValue([Baseline Finish])=4294967295, "True", "False") is
the check I use.

In what type of field are you using the formula? For the formula to
work as written I believe you will have to use a text field.

Hope this helps...
Susan Cobb

 

[Dale Howard [MVP]]

Nik003 --

Try the following formula in an enterprise Project or Task text field:

IIf(ProjDateValue([Baseline Start])="NA","Not Baselined","Baselined")

You were using the ProjDateValue function incorrectly in your previous
formula. If you use the formula in a Task field, remember to select the
"Use Formula" option in the Custom Fields dialog to apply the formula to all
summary tasks in the project. Also, after adding the formula to Project
Server 2007, your PM's will probably need to open each of their projects and
press the F9 function key to recalculate the project and formula. Ask them
to insert the new column temporarily in a Task view such as the Gantt Chart
view so make sure the formula is working. If you create the formula in a
Project text field, ask them to click Project - Project Information to make
sure it works. Hope this helps.

 

[Gary L. Chefetz [MVP]]

Try:

projdateval([yourfield]) = "NA"

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Worried]

I have one question, please help.
I've created task custom field called Location, with two values. One of that
values I set to be default and I specified that custom fields as required.
But, in project table that column don't have default value (it is empty) and
when I try to save project it reports error: Required field value: Location.
What I have to do to set default value for custom field, so that a don't have
to fill it evry time???
Thanks

Try:

projdateval([yourfield]) = "NA"

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

Project Server 2007

I am trying to create a custom field that determines if a project is
baselined or not. I'll be using this later in a check for other fields. I
have tryed this:

IIf([Baseline Finish]>50000,"False","True")

as well as other cobinations I have found on the web:


IIf([Baseline Finish]=ProjDateValue("NA"), “No Baseline Set†, “Baseline
Setâ€)
IIf(ProjDateValue([Baseline Finish])=4294967295, “Trueâ€, “Falseâ€)

But for some really weird reason I get only #ERROR returned. This does not
make much sense to me.

Anybody?

 

[Dale Howard [MVP]]

Worried --

The default value in this field is set automatically by the system ONLY when
a user creates a new task. Otherwise, for existing tasks in existing
projects, the PM must manually specify a value in this field. To speed up
the data entry process in this field, the PM's can enter a value for one
task, and then use the Fill Handle to fill the same value into the field for
multiple tasks. Hope this helps.

I have one question, please help.
I've created task custom field called Location, with two values. One of
that
values I set to be default and I specified that custom fields as required.
But, in project table that column don't have default value (it is empty)
and
when I try to save project it reports error: Required field value:
Location.
What I have to do to set default value for custom field, so that a don't
have
to fill it evry time???
Thanks

Try:

projdateval([yourfield]) = "NA"

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

Project Server 2007

I am trying to create a custom field that determines if a project is
baselined or not. I'll be using this later in a check for other fields.
I
have tryed this:

IIf([Baseline Finish]>50000,"False","True")

as well as other cobinations I have found on the web:


IIf([Baseline Finish]=ProjDateValue("NA"), "No Baseline Set" ,
"Baseline
Set")
IIf(ProjDateValue([Baseline Finish])=4294967295, "True", "False")

But for some really weird reason I get only #ERROR returned. This does
not
make much sense to me.

Anybody?