Solved

Partial Text Match Formula - Name Contains

+1

I can’t figure out a simple formula.

Name (field) = John Smith

I need the formula to come up with a result if the search for “Smith” is true.

I tried IF(FIND('Smith', Name) > 0)

Does not work. Please share ideas.

Best answer by slyfox

Your IF function is incomplete. You do not say what you want to display if the field contains Smith.

Try

IF(FIND('Smith', Name), 'Name contains Smith')

Anyway to make this work as True/False ?

TRUE(IF(FIND('John Smith', Name)>0))

TRUE(IF(FIND('Smith', Name)))

EDIT: I think I got it, IF(FIND('Smith', Name), TRUE())

+29

Your IF function is incomplete. You do not say what you want to display if the field contains Smith.

Try

IF(FIND('Smith', Name), 'Name contains Smith')

+1

Your IF function is incomplete. You do not say what you want to display if the field contains Smith.

Try

IF(FIND('Smith', Name), 'Name contains Smith')

Anyway to make this work as True/False ?

TRUE(IF(FIND('John Smith', Name)>0))

TRUE(IF(FIND('Smith', Name)))

EDIT: I think I got it, IF(FIND('Smith', Name), TRUE())

Sign up