Help

Concatenate text fields put NaN in field

Topic Labels: Formulas
Solved
Jump to Solution
978 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lynda_Stringer
6 - Interface Innovator
6 - Interface Innovator

I.m new to Airtable. I’m trying to concatenate the nickname if the field isn’t empty or the first name if no nick name then a space then the last name. It puts NaN in the field. Here is my code in a formula field:
CONCATENATE(IF(nickname="",First,nickname)+" "+Last)

1 Solution

Accepted Solutions
Esabatad_Daeh
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Lynda,

Try replacing your + characters with & symbols.
See if that helps. :blush:

See Solution in Thread

2 Replies 2
Esabatad_Daeh
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Lynda,

Try replacing your + characters with & symbols.
See if that helps. :blush:

Lynda_Stringer
6 - Interface Innovator
6 - Interface Innovator

That worked, thanks so much.