I need a formula field for my reporting where if Field value length for First Name or Last Name = 3 or more characters.

I tied this so far

IF (ISBLANK(Firstname)0,1 IF (ISBLANK(Lastname) 0,1 IF(ISBLANK(Email) 0,1

  • 2
    It's unclear what you're asking because the formula you've tried so far doesn't make much sense. Is the desired result to display the Email if the first name or last name is greater than 2 characters? – Drew Kennedy Aug 6 '19 at 17:36
  • I am trying to use formual field as a filter on a report. Wants to display results where Field value length for First Name or Last Name is equal to 3 or more characters on Contact. – DRose Aug 6 '19 at 17:39
  • Wouldn't LEN(FirstName) > 2 || LEN(LastName) > 2 be enough on a checkbox formula? – Drew Kennedy Aug 6 '19 at 17:46
  • @DrewKennedy. Yes it worked. thanks for the help . – DRose Aug 6 '19 at 18:19

Formula field with return type of "Checkbox":

OR( LEN(FirstName) > 2, LEN(LastName) > 2 )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.