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?