Skip to main content

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.


Make a formula field using the following formula:



IF(


   FIND("registercitizen",{link}),


   "Register Citizen", 


   IF(


       FIND("rep-am",{link}),


       "Republican American",


       "Some other source"


   )


)

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!

Reply


Terms & Conditions