
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- If “registercitizen” is found in the
link
column, populate thesource
column with the selection “Register Citizen” - If “rep-am” is found in the
link
column, populate thesource
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2018 12:04 PM
:thumbs_up: Nailed it, @Kamille_Parks - thank you!
