I have a column in my Google Sheet that contains the title of each of our e-blasts from the past 7 years. I want to create a column that provides the "type" of the e-blast, using IF/SEARCH or something similar to find a substring in the first column and return a string in the last column.
We didn't necessarily label each event invitation with the word "invitation," for example — e.g., there were some invitations labeled as "reminder." :(
Basically, I want to search for a set of words like "reminder" and "invitation" and have the cell return the string "Event Invite." But here's where I'm running into trouble: In the same stroke, I need to also search the cell for the substring "e-blast" and have it return "Newsletter," and "follow up" should return "Recap," and so on.
Thanks so so much in advance for any advice!!
PS: Here's what I'm trying, but it returned an error.
=ArrayFormula(IFNA(IFS(SEARCH(”Reminder| Date| Webinar| Conference| Invitation| Invite| Fireside| Session| Fair| Panel”,C4:C)=true,”Event”, SEARCH(”Newsletter| Blast”,C4:C)=true,”Newsletter” SEARCH(”Apply| Applications”,C4:C)=true,”Call for Applications” SEARCH(”Recap| Recording| Follow”,C4:C)=true,”Recap”)))