Partial Text Match Formula - Name Contains

[slyfox]

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.

[kuovonne]

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')

[slyfox · Accepted solution]

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())