Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

2419 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan_Dobos
5 - Automation Enthusiast
5 - Automation Enthusiast

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 Replies 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"
   )
)

:thumbs_up: Nailed it, @Kamille_Parks - thank you!