Skip to main content

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. 😊

That worked, thanks so much.

Reply


Terms & Conditions