Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

# IF text from field matches, return X

Topic Labels: Formulas
Solved
Jump to Solution
1327 2
cancel
Showing results for
Search instead for
Did you mean:
4 - Data Explorer

I’m hoping someone can assist me with creating a formula. The formula should look at the field Article Title. We have thousands of articles. If any article contains a particular phrase, the field should return a specified URL. For example, we may have 10 articles with the word Movies in the title. For those ten articles, the formula should output https://www.imdb.com. More specifically, the article with the title Top 10 Movies of All Time would result in https://www.imdb.com in the field.

This is what I have thus far and it’s not working, at all.

IF(
FIND(
“Movies”,
{Article Title}, ‘https://www.imdb.com’,
)
)

Thanks in advance.

1 Solution

Accepted Solutions
18 - Pluto

You do not need to compare the results of the `FIND` function to 0. The `IF` function evaluates the “truthiness” of 0 as false. The actual problem with your formula was a misplaced closing parentheses. You need to move the parenthesis so that it closes the `FIND` function.

``````IF(
FIND("Movies", {Article Title}),
'https://www.imdb.com'
)
``````
2 Replies 2
18 - Pluto

The “FIND” function results in a number, telling you the position of the first character that begins the phrase that you’re looking for.

So, this is the formula that you would want:

IF(
FIND( “Movies”, {Article Title} ) > 0,
https://www.imdb.com
)

18 - Pluto

You do not need to compare the results of the `FIND` function to 0. The `IF` function evaluates the “truthiness” of 0 as false. The actual problem with your formula was a misplaced closing parentheses. You need to move the parenthesis so that it closes the `FIND` function.

``````IF(
FIND("Movies", {Article Title}),
'https://www.imdb.com'
)
``````