formula field - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Jessica EaganJessica Eagan 

formula field

Hello!

I am looking to create a formula as to where if First Name and Last Name are both populated, the formula returns a "1".  Thank you!
Best Answer chosen by Jessica Eagan
Jasleen MakkarJasleen Makkar
Hi Jessica,

If you are looking for a formula field, the following should work

IF( AND (NOT(ISBLANK(FirstName)) ,NOT(ISBLANK(LastName)), NOT(ISNULL(FirstName)), NOT(ISNULL(LastName))),1,0)

You can replace the field names with the ones that you have in your object.

Regards,
Jasleen