Dec 26, 2018 09:25 PM
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:
link
column, populate the source
column with the selection “Register Citizen”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.
Dec 26, 2018 10:56 PM
Make a formula field using the following formula:
IF(
FIND("registercitizen",{link}),
"Register Citizen",
IF(
FIND("rep-am",{link}),
"Republican American",
"Some other source"
)
)
Dec 27, 2018 12:04 PM
:thumbs_up: Nailed it, @Kamille_Parks - thank you!