Table design to account for different street and mail address if a mailing list is required

[Scott_Brasted]

Hello Community,

I need to have an address table that deals with some people having different street and mail addresses and some having only a street address. How can I structure the table to allow for both while being able to filter for a list for mailings? Any thoughts would be appreciated.

Thanks, Scott

[TheTimeSavingCo · Accepted solution]

Do you think we could use a formula field to compile the fields like so?

IF(
  {Mailing Address},
  {Mailing Address},
  {Street Address}
)

Link to base

[Scott_Brasted]

Duh! I'm embarrassed that I did not think of that. Yikes! A mind is a terrible thing to lose. Thank you! Scott