Concatenate text fields put NaN in field

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)

Hi Lynda,

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

That worked, thanks so much.

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