Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF this field is full use it otherwise use this field

Topic Labels: Formulas
652 1
cancel
Showing results for 
Search instead for 
Did you mean: 
IFconfused
4 - Data Explorer
4 - Data Explorer

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
1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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.