Help with Primary field formula

+8

Hi there

I’m wanting to NOT show the “and” if the {Preferred - CB} is blank. Currently, it looks like this: Smith, Mark and Suzie

And here’s my current formula:
{Last Name} & " , " & {Preferred - B} & " and " &{Preferred - CB}

Any ideas? Thanks in advance!

This topic has been closed for replies.

+17

Check that first:

{Last Name} & " , " & {Preferred - B} & IF({Preferred - CB}, " and "&{Preferred - CB})

+8

This worked perfectly! Thank you Elias.

Sign up