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!
