+9Good day all. I am trying to create a formula to name my Clients based on the following:
If {company} is not blank, use {company} and if {company} is blank use {last name}, {first name} - and if there is a spouse name use {last name}, {first name} & {spouse name}
I can't quite get it to work - can anyone help?
Best answer by TheTimeSavingCo
Does this look right?
IF(
Company,
Company,
{Last Name} & ", " & {First name} &
IF(
{Spouse Name},
", " & {Spouse Name}
)
)
+31Does this look right?
IF(
Company,
Company,
{Last Name} & ", " & {First name} &
IF(
{Spouse Name},
", " & {Spouse Name}
)
)
+9Beautiful, thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.