Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Hide additional characters when no value available

Topic Labels: Formulas
Solved
Jump to Solution
612 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

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}

See Solution in Thread

2 Replies 2

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}

Worked perfectly, thanks for your help!