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! 

Terms & ConditionsAccessibility statement