D
DogLBer
Server 2007, SP1, w DecCU
I'm trying to perform the simple task of setting a flag for a particular
milestone task, having a second field read the flag and display the task
finish date. Creating the flag field, both Ent and Local fields is no
problem. Creating a simple IIF statement is another story. I have two
symptoms that occur with this formula
IIf( [BC Test Flag]="yes", [Finish], 'no sale' ).
1. If I build it in Pro as a local field in either a date or text field,
upon clicking OK it changes the BC Test Flag to Flag10 and evaluates it as"no
Sale" even when the flag is set. I have tried this with the flag field as a
Ent field and as a local field with no difference in symptom. I hav tried
making the flag a text field with a yes/no drop down. No difference. I have
tried single quotes (') and double quotes ("), no difference.
2. In PWA/Ent Custom Field Def I can build the flag field, but when I
attempt the formula in a Text or Date field it give me "The formula contains
a syntax error or contains a reference to a unrecgnized field or function
name."
Also I tried the function picker and free handing the formula, no
difference, and I am working at the task level not trying to go to a project
field with it.
After two days of trying and failing I have to assume I'm do something
basically wrong and won't spot it myself. Can some fresh eyes tell me where I
am erroring?
I'm trying to perform the simple task of setting a flag for a particular
milestone task, having a second field read the flag and display the task
finish date. Creating the flag field, both Ent and Local fields is no
problem. Creating a simple IIF statement is another story. I have two
symptoms that occur with this formula
IIf( [BC Test Flag]="yes", [Finish], 'no sale' ).
1. If I build it in Pro as a local field in either a date or text field,
upon clicking OK it changes the BC Test Flag to Flag10 and evaluates it as"no
Sale" even when the flag is set. I have tried this with the flag field as a
Ent field and as a local field with no difference in symptom. I hav tried
making the flag a text field with a yes/no drop down. No difference. I have
tried single quotes (') and double quotes ("), no difference.
2. In PWA/Ent Custom Field Def I can build the flag field, but when I
attempt the formula in a Text or Date field it give me "The formula contains
a syntax error or contains a reference to a unrecgnized field or function
name."
Also I tried the function picker and free handing the formula, no
difference, and I am working at the task level not trying to go to a project
field with it.
After two days of trying and failing I have to assume I'm do something
basically wrong and won't spot it myself. Can some fresh eyes tell me where I
am erroring?