ChrisJewell
Computer
- Jun 1, 2009
- 1
I have a custom Start field configured in MS Project and I want to sync that date with a task Start date subject to the project type being something specific. I want to do it through a Formula in a Custom Field.
So far I can get the field to match the date that I want when the Project Type is what I want. But when I do this and the project type is not the right value, it returns #Error. I want it just to be Null. I know really simple, but can you help me….pleaseJ
Current formula: IIf([Text5]=("Full Release"),[Start])
Now the syntax is fairly straight forward:
Returns one of two parts, depending on the evaluation of an expression.
Syntax
IIf( expr, truepart, falsepart )
expr Required; Variant expression you want to evaluate.
truepart Required; value or expression to be returned if the corresponding expression is True.
falsepart Required; value or expression to be returned if the corresponding expression is False.
I am obviously having problems with the falsepart ie I don’t know what to put to make the field to be blank!!
So far I can get the field to match the date that I want when the Project Type is what I want. But when I do this and the project type is not the right value, it returns #Error. I want it just to be Null. I know really simple, but can you help me….pleaseJ
Current formula: IIf([Text5]=("Full Release"),[Start])
Now the syntax is fairly straight forward:
Returns one of two parts, depending on the evaluation of an expression.
Syntax
IIf( expr, truepart, falsepart )
expr Required; Variant expression you want to evaluate.
truepart Required; value or expression to be returned if the corresponding expression is True.
falsepart Required; value or expression to be returned if the corresponding expression is False.
I am obviously having problems with the falsepart ie I don’t know what to put to make the field to be blank!!
