IF this field is full use it otherwise use this field

[IFconfused]

Hi,

I am creating a formula for my fixed field for a sponsor base. Not all sponsors have business names; therefore I am looking for a formula that will be something along the lines of:

IF({Business Name (from Contacts)}, {Business Name (from Contacts)}, "{Contacts}"). However, the " " shows up as the physical text rather than what is in the Contacts field. 

What should I be doing instead?

P

[kuovonne]

If you want the value of the {Contacts} field, omit the quotes around it.

IF(
  {Business Name (from Contacts)},
  {Business Name (from Contacts)},
  {Contacts}
)

 FYI, thanks for including the screen shot, but you cropped out the names of your fields in the screen shot, so it is a little hard to tell which field is which. I think that the first field is your formula field, but I cannot tell which fields are {Business Name (from Contacts)} or (Contacts}, although I suspect that they are not included in the screen shot at all. In general, it is best if you include all relevant fields in the screen shot, including the field names.