Help

Re: IF text from field matches, return X

Solved
Jump to Solution
554 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Mei
4 - Data Explorer
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
kuovonne
18 - Pluto
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'
)

See Solution in Thread

2 Replies 2

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