Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Concatenate text fields put NaN in field

Topic Labels: Formulas
Solved
Jump to Solution
1588 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.