Forum Discussion
IsBlank return with a specific value
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. ...
amitchandak
Super User
Super UserAnonymous , not very clear. Try a new column like
Switch(true(),
isblank([column]) || [column] ="" ,"Unknown",
search("hospi",[column],,0) >0, "Hospitality",
"Other"
)
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?