IF statement to join 2 first names only

I have set up on a contact layout to have a partner/spouse with secondary first and last name fields.

I'm trying to set up a formula field where if the secondary name is empty, the only the first name will appear in the 'letter' formula field, but if there is a secondary name then the formula should conjoin the two names together as "name and name2".

I've tried to do this as both boolean and string, but each time it gives a bracket error but I cannot find the error to resolve.

I am unsure if I should be using ==null, or empty, or something else for the IF statement to check if the text field in question is empty or not. If I use just the concat part of the code I receive no errors, it is only when trying to include it as part of an IF statement.

The code I am using:

if(${Contacts.Secondary First Name}==null,${Contacts.First Name},concat(${Contacts.First Name},' and ',${Contacts.Secondary First Name}))

Any help or ideas greatly appreciated!!

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
Introducing Zia Presentation in Zoho CRM
----------------Moderation 3.0, Date: 10th May'24--------------------------------------- Zia's Presentation feature is now available for orgs in US, EU, IN, CN, JP, and AU DCs. Orgs., with Enterprise or Ultimate editions with 20+ user licenses can access
New capabilities for custom buttons: Elevate UX and CX with just a click!
Dear Customers, We hope you're well! We're happy to announce enhancements we've made to buttons. Buttons in Zoho CRM are a simple yet versatile customization tool. It offers great usability for CRM users, enabling them execute important actions as required.
Enrich your CRM data and keep them updated
You spend a lot of your time and efforts in generating quality leads for your business. While generating leads is a challenge in itself, the real deal begins when sales reps try to nurture these leads and convert them as customers. So how equipped is your sales team with information about your leads matters a lot. For example, you might be using webforms to generate leads and collect customer information from your website. The lesser your webform fields are, the more your sign-ups right? From optimizing
Zoho CRM Digest - February 2024
We're thrilled to bring you the February digest, packed with exciting product updates and engaging discussions from the Zoho CRM Community. Keep reading to stay in the loop! Product Updates: Zia Enhancements Be it Tasks, Calls, or Meetings, Zia's activity
Canvas templates can now be shared with different CRM organizations
----------------------------------------Moderated on 14th February, 2023------------------------------------------- Dear all, This feature is now open for all users in all DCs. To learn more about importing and exporting canvas templates, read our help