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!!