Error in formula (2nd try)

[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...?

Thank You,

Erkki

 

[10K]

I did exactly as you described and it works for me. The formula I used is:
IIf([Name]="Submit deliverable acceptance",[Start],"NA")

What error did you get?

A tip: you may have tried to type in the formula. Use the Insert Field and
Function buttions (just beneath the operator icons, which is just below the
text input area) to get the templates for the formulas and fields.

The formulas and examples are "documented" in the templates in the Insert
Function button.
Good luck,
10K

 

[57chevy]

Erkki, I believe you should be using a comma "," instead of a semi-colon ";"
between the arguements.
IE
IIF([Name]="Some task name",[Start],"NA")

 

[Erkki]

Thank You very much.

I'll try inserting fields and functions. I've read the service pack 1
documentation and found a fix that maybe corrects the problem (in this exotic
finnish version).

Erkki

I did exactly as you described and it works for me. The formula I used is:
IIf([Name]="Submit deliverable acceptance",[Start],"NA")

What error did you get?

A tip: you may have tried to type in the formula. Use the Insert Field and
Function buttions (just beneath the operator icons, which is just below the
text input area) to get the templates for the formulas and fields.

The formulas and examples are "documented" in the templates in the Insert
Function button.
Good luck,
10K

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...?

Thank You,

Erkki

 

[Erkki]

Thank You !

I did not tell, that this customer uses the finnish version and so the
delimeters between arguments are semi-colons. The service pack 1 update migt
also be useful (there is a probable cause for this in the finnish version).

Have a nice weekend.

Erkki

Erkki, I believe you should be using a comma "," instead of a semi-colon ";"
between the arguements.
IE
IIF([Name]="Some task name",[Start],"NA")

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...?

Thank You,

Erkki