
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2020 03:40 PM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2020 03:58 PM
Hi Lynda,
Try replacing your + characters with & symbols.
See if that helps. :blush:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2020 03:58 PM
Hi Lynda,
Try replacing your + characters with & symbols.
See if that helps. :blush:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 21, 2020 04:00 PM
That worked, thanks so much.
