Nov 05, 2020 01:51 PM
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.
Solved! Go to Solution.
Nov 05, 2020 02:01 PM
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())
Nov 05, 2020 02:00 PM
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')
Nov 05, 2020 02:01 PM
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())