Hide additional characters when no value available

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!

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}

2 Likes

Worked perfectly, thanks for your help!

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.