Feb 02, 2024 12:49 PM
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:
Solved! Go to Solution.
Feb 02, 2024 10:21 PM
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:
Feb 02, 2024 10:21 PM
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:
Feb 07, 2024 09:25 AM
This worked, thank you so much!