Error in formula

[Erkki]

Hi.

I have customized a date field with the following formula : IIF
([Name]="Some task name";[Start];"NA")
Calculation for task and group summary rows is set to : Rollup - Maximum.
My aim is to move a certain tasks start date to project field in order to
show it in
Project center.

This produces an ERROR in the custom date field. Any ideas ?

PS Where are the formulas documented - syntax, examples...?
Sorry, if you have encounterd this message elsewhere - I happened to post
it in the archives...

Thank You,

Erkki

 

[Mike Glen]

Hi Erkki,

Welcome to this Microsoft Project newsgroup

The quotes in "NA" put it in the field as text, which a date field doesn't
like. Try removing the quotes and use NA on its own

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on )

Mike Glen
MS Project MVP