Multiple IsEmpty Statements

[Adam_B]

Hello all, 

I have a data set with with Columns named Category Level 2, Category Level 3, and Category Level 4.  Some of the data those columns is BLANK.  So I would like to replace the BLANK with "UNKNOWN".  

I have tried this formula:

IF
!IsEmpty([Category Level 2]) THEN [Category Level 2]
ELSEIF !IsEmpty([Category Level 3]) THEN [Category Level 3]
ELSEIF !IsEmpty([Category Level 4]) THEN [Category Level 4] ELSE
"Unknown"
ENDIF

However, it is not working, I am receiving this error: 

Any help would be appreciated. 

Thanks, 

Adam 

[Emil_Kos · Accepted solution]

Hi @Adam_B,

You need to pick a column name. Probably you forgot to do that. 

[Qiu · Accepted solution]

@Adam_B 

Just as @Emil_Kos pointed out, the new column name is not set.

[Adam_B]

Thank you!