IF formula to find text in a cell and make a selection in another cell?


#1

I’ve seen a few threads on this topic, but none closed the loop for me.
I’m trying to say that “if these characters are in a cell, select this option”

I have numerous news websites’ RSS feeds populating a single table, and I want to make a column called “source” to give the name of the publication. I figured I could use the URL to determine who the source is.

This is the logic I am trying to automate:

  • If “registercitizen” is found in the link column, populate the source column with the selection “Register Citizen”
  • If “rep-am” is found in the link column, populate the source column with the selection “Republican American”

In this screenshot, you see the desired end result. I just want to have the source column populated automatically based on text in the link column.
43%20AM


#2

Make a formula field using the following formula:

IF(
   FIND("registercitizen",{link}),
   "Register Citizen", 
   IF(
       FIND("rep-am",{link}),
       "Republican American",
       "Some other source"
   )
)

#3

:+1: Nailed it, @Kamille_Parks - thank you!