Skip to main content

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.

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”

)

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'

)

Reply


Terms & Conditions