Partial Text Match Formula - Name Contains

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.

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.