Skip to main content

Good 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? 

Does this look right?

IF(
Company,
Company,
{Last Name} & ", " & {First name} &
IF(
{Spouse Name},
", " & {Spouse Name}
)
)

 

Beautiful, thank you! 

Reply


Terms & Conditions