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)
Solved
Concatenate text fields put NaN in field
+1Best answer by Esabatad_Daeh
Hi Lynda,
Try replacing your + characters with & symbols.
See if that helps. :blush:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.