Custom Address Column

[bdehning]

I am using the following Custom Column Formula to create a column of locations with address, city, state and zip code. 

= [Injury Location Address1]&", "&[Injury Location City]&", "&[Injury Location State]&" "&[Injury Location Zip Code]

It almost works but I if one of the 4 location columns is null, it considers the whole address null for the custom column.  

What can I do to the above formula or in a different way allow the address to show inmy custom column if at least one of the four has proper data.  

[bdehning · Accepted solution]

I went ahead and Merged all 4 columns and that worked as expected as compared to my Custom Column.   

[bdehning]

I should have said I am not getting the partial addresses to show if there is a null value in any of the 4 column fields for a single addess.  

Could the null values be the issue and I need to have the null show as blank or somethiing else so that I see what the column can merge?

[tamerj1]

@bdehning 

Sorry I'm not to pickup the idea.

[tamerj1]

Hi @bdehning 

it shouldn't. There must be something else.