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
Solved! Go to Solution.
@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