Hello!
I'm trying to create a formula that will create First Name (Goes By Name) Last Name (Business Name). I've gotten my formula so that I can get all those pieces together, however if either Goes By or Business Name exists and the other doesn't, I'm getting () included still.
For example
Katelyn () Grant (Airtable) or Katelyn (Kate) Grant ()
How do I get it to not include the () if the field is empty?
Here's the formula:
IF(
OR({Goes By Name}, {Business Name}),
{First Name} & " " & "(" & {Goes By Name} & ")" & " " & {Last Name} & " " & "(" & {Business Name} & ")",
{First Name} & " " & {Last Name})
