Skip to main content
Solved

IF text from field matches, return X

  • May 6, 2020
  • 2 replies
  • 19 views
C

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.

Best answer by kuovonne

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

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • May 7, 2020

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
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • Answer
  • May 7, 2020

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'
)
ScottWorld
Terms & ConditionsAccessibility statement