The following formula is showing as a malformed if statement:
if Length([state]) = "2" then [State2] else [state]
Both State columns are listed as string data types
Solved! Go to Solution.
You missed an ENDIF at the end of your formula.
Besides, Length formula results in a number, it can't be a string.
if Length([state]) = 2 then [State2] else [state] ENDIF
Cheers,