Create a new Formula field. return Field value if Field length for First Name or Last Name = 3 or more characters

Question

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

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

Bow-chicawow-ers · Accepted Answer · 2019-08-06 18:19:54Z

1

Formula field with return type of "Checkbox":

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

answered Aug 6 '19 at 18:19

Bow-chicawow-ers

2,22510 silver badges30 bronze badges

Add a comment |

1 Answer 1