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.
I have one field that I would like to generate from three other ones. First Name, Last Name and Company
If there is a first and last name in the directory I would like to display it as the following:
Last Name, First Name
If there is no person’s name...
Jeremy_Oglesby:
IF(AND({First Name}!=BLANK(),{Last Name}!=BLANK()),CONCATENATE({Last Name},", “,{First Name},” ",Company),Company)
Hi Jeremy,
Tha formula actually doesn’t report an error “invalid formula” like the first one you posted, so tech...
