My goal is to have a formula to populate New Profile from either Legacy Profile or a Concatenate of Company Responsibility, Professional Background, Educational Background. Ideally for the Concatenate portion, I can have the three fields with a parag...
Can I please get some assistance with a conditional statement. I’ve looked at examples, but have not been able to crack this.
Goal: First Name space Middle Initial space Last Name or First Name space Last Name
Not all names have a middle initial ther...
@Aron, thank you for the update and the logic statement. It helped me debug two things.
Aron:
CONCATENATE({First Name},if({Middle Initial}="",""," “&{Middle Initial}&” "),{Last Name})
A space was needed between the middle set of quotes to have...
Aron, thanks for the assistance.
The formula is returning as an invalid formula. Could you check, and would you mind also sharing the “logic” statement so I can get better at writing these in the future?
Such as:
Concatenate {First Name}, if {Middle ...
