+1Hi! I need to create a formula that concatenates the First Name and Last Name columns. I could do that part easily enough. But I also need it to look to see if there’s a value in the Preferred Name field and if that field has a value in it, to substitute that for the First Name.
Is this possible? How would I do this?
Here’s a screenshot, for reference:
+6Hi Ashley,
try something like this:
CONCATENATE(
IF(
TRIM({Preferred Name})
, {Preferred Name}
, {First Name}
)
, " "
, {Last Name}
)
This should do the work
+1Hi Ashley,
try something like this:
CONCATENATE(
IF(
TRIM({Preferred Name})
, {Preferred Name}
, {First Name}
)
, " "
, {Last Name}
)
This should do the work
That worked perfectly. Thank you so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.