Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Partial Text Match Formula - Name Contains

Topic Labels: Formulas
Solved
Jump to Solution
872 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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