This formula works: IF [Right_Amazon Siebel Brand] THEN [Amazon Siebel Brand] ELSE [Right_Amazon Siebel Brand] ENDIF
However: Want to add if is null, but this formula does not work, balance of formula turns black. What is wrong with formula?
IF (isnull([Right_Amazon Siebel Brand]) THEN [Amazon Siebel Brand] ELSE [Right_Amazon Siebel Brand] ENDIF
Solved! Go to Solution.
Hi @CherylH
Try this
IF isnull([Right_Amazon Siebel Brand])
THEN [Amazon Siebel Brand]
ELSE [Right_Amazon Siebel Brand] ENDIF
There was a extra ( in your pasted formula.
Hi @CherylH
You can also try
IF isempty(Trim([Right_Amazon Siebel Brand]," "))
THEN [Amazon Siebel Brand]
ELSE [Right_Amazon Siebel Brand] ENDIF
So that it removes empty blanks also.
Thank you so much it worked. What a difference a ( makes. Knew I was close but could not get it.