If Then Statements Overwriting Other Formulas

[greenman73]

Hi there,

Having an issue where i have 3 If, then statements using the Formula widget and i am trying to add a day count to a row based on a word from a cell within that same row.  If i run them individually the days load as expected but when i run all 3 together the days are wiped out completely.  If if i create 3 different formula widgets in a row in the design chain each step overwrites the other.  Not sure what i am doing wrong here as i have never experienced this before with other if, then statements.

Attached are the formulas.

thanks

Jonathan

[aatalai]

@greenman73 try this

If isNull([Field1])

then [Field2]

elseif isNull([Field2])

then [Field3]

else Null()

endif

but agreed with @alexnajm comment re starting a new thread