Forum Discussion
Custom Address Column
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.
I went ahead and Merged all 4 columns and that worked as expected as compared to my Custom Column.
4 Replies
I went ahead and Merged all 4 columns and that worked as expected as compared to my Custom Column.
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?
