Help with Primary field formula


#1

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!


#2

Check that first:

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


#3

This worked perfectly! Thank you Elias.