IsBlank return with a specific value

[Anonymous]

Hello Experts,

I am trying to return null/blank fields with a specific variable. for example.

I have a calculated field with multiple "containstring" formula to group a specific category. 

CONTAINSSTRING(table name, "hospi"), "Hospitality"

I would like to return unknown category  with a variable called "Unknown" in same column. I tried isBlank function, But my calculated column name is not appearing under inBlank function

Would be great help if you could assist me with this.

thanks

if

[amitchandak]

@Anonymous , not very clear. Try a new column like

Switch(true(),
isblank([column]) || [column] ="" ,"Unknown",
search("hospi",[column],,0) >0, "Hospitality",
"Other"
)

[Anonymous]

Hi @amitchandak ,

I've created a new calculated column to group categories and give a unique name. I would like to return "Unknown" in my calculated column wherever there's blank. I am unsure about some categories which was listed in main column. Hence I would like to return them as "Unknown". Current calculated column;

SWITCH(TRUE(),

CONTAINSSTRING (col1,"hospi") || CONTAINSSTRING(col2,"A0172") , "Hosiptals")

I have several other categories which I've extracted/grouped them from other columns

Can I include isblank function within same calculated column? If so then how?