Help

Confused about IF() formatting

1005 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Cady_Smith
4 - Data Explorer
4 - Data Explorer

I’m having trouble figuring out the correct formula format. I’m using a formula in the primary column to show what the other columns say.
My three columns are single line text: {Code}, {Name 1}, {Name 2}

If Name 2 is empty, I want it formatted like this: VLG1234 | Jackie Doe
If Name 2 isn’t empty I want it formatted like this: VLG1234 | John Doe & Jane Doe

I’m using this formula: {Code} & " | " & {Loan Officer} & IF({Realtor}=BLANK(),BLANK(),{Realtor})
If Name 2 is empty it works: VLG1234 | Jackie Doe
If Name 2 isn’t empty: VLG1234 | John DoeJaneDoe

Basically I’m not sure how to format it to get the & in there.

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

You’re missing the " & " between John Doe and Jane Doe. Correct your formula to be:

{Code} & " | " & {Loan Officer} & IF({Realtor}=BLANK(),BLANK()," & " & {Realtor})