This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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},” ", {...
