IF text from field matches, return X

[Christopher_Mei]

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.

[ScottWorld]

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

[kuovonne · Accepted solution]

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