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.
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.
Jul 21, 2020 03:58 PM
Hi Lynda,
Try replacing your + characters with & symbols.
See if that helps. :blush:
Jul 21, 2020 03:58 PM
Hi Lynda,
Try replacing your + characters with & symbols.
See if that helps. :blush:
Jul 21, 2020 04:00 PM
That worked, thanks so much.