I’m trying to write a formula to a field that will write someone’s name based on conditions. If {preferred name} is filled, the formulae outputs {preferred name}&" "&{last name}
otherwise, the formula output is {first name}&" "&{last name}
I can’t seem to write the if statement so it works. Any thoughts?
+25The formula would be: IF({preferred name},{preferred name},{first name})&' '&{last name}
The logic of the formula above is: IF {preferred name} is not empty, insert value of {preferred name}, otherwise insert value of {first name}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
