Hide additional characters when no value available

[rossmcleod]

Hello! I have a formula which builds record names based on the values of other columns:

{Name} & " (with " & {Secondary Name} & ") " & " - " & {Event} & "\n " & {Year} & " | " & {Room}
Result: John (with Jim) - Conference 2020 | Green Room
However if there’s nothing in “Secondary Name” it displays:
John (with ) - Conference 2020 | Green Room

How do I get it to remove the "(with ) " when there’s nothing to fill it with? The secondary names are linked to other records so unfortunately I can’t just add the brackets to the column entry instead of putting them in the formula.

Thanks in advance!

[Kamille_Parks · Accepted solution]

Revise your formula like the following. What you need is an IF() statement to check if the {Secondary Name} field is filled in:

{Name} & IF({Secondary Name}, " with (" & {Secondary Name} & ")") & " - " & {Event} & "\n " & {Year} & " | " & {Room}

[rossmcleod]

Worked perfectly, thanks for your help!