I am trying to create a field that shows consolidated address information based on which field has information in it. Show the Shipping Address unless it is blank, then show the Billing Address. I want to make several separate fields - Address, City, State, ZIP, Country. I am getting the error: "Formula result is data type (Location), incompatible with expected data type (Text)".

My formula is: IF(  ISBLANK( ShippingAddress ) ,  BillingAddress , ShippingAddress)

There is no option in Formula to make the type "Location" only "Text".

Any help on how to make the formula would be appreciated.