Help

not include () if blank

Topic Labels: Formulas
Solved
Jump to Solution
181 2
cancel
Showing results for 
Search instead for 
Did you mean: 
katelyngrant
4 - Data Explorer
4 - Data Explorer

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})

 

1 Solution

Accepted Solutions
TheTimeSavingCo
16 - Uranus
16 - Uranus

Hm, I think I'd set up my formula to be like so instead:

{First Name} & " " &
IF(
  {Goes by Name},
  "(" & {Goes by Name} & ") "
) &
{Last Name} &
IF(
  {Business Name},
  " (" & {Business Name} & ")"
)

Resulting in:
Screenshot 2024-02-03 at 2.20.58 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
16 - Uranus
16 - Uranus

Hm, I think I'd set up my formula to be like so instead:

{First Name} & " " &
IF(
  {Goes by Name},
  "(" & {Goes by Name} & ") "
) &
{Last Name} &
IF(
  {Business Name},
  " (" & {Business Name} & ")"
)

Resulting in:
Screenshot 2024-02-03 at 2.20.58 PM.png

katelyngrant
4 - Data Explorer
4 - Data Explorer

This worked, thank you so much!