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.
Hey,
Oh that’s strange! I wonder if the first Suffix needs {} around it.
It is working for me so I wonder if my field names are slightly different to yours.
Otherwise, if you delete and then try to manually input the formula (using the existing as a ...
Hey @Juraj_Ivkovac,
If I have understood correctly, you’re correct in that you want to use an IF statement as below.
IF(Suffix != “”, CONCATENATE({Prefix}," “,{First Name},” “, {Last Name},”, “, {Suffix}), CONCATENATE({Prefix},” “,{First Name},” ", {...