Help

Partial Text Match Formula - Name Contains

Topic Labels: Formulas
Solved
Jump to Solution
1573 2
cancel
Showing results for 
Search instead for 
Did you mean: 
slyfox
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
slyfox
6 - Interface Innovator
6 - Interface Innovator

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

See Solution in Thread

2 Replies 2

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
6 - Interface Innovator
6 - Interface Innovator

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