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.

Operator for Contains

Topic Labels: Formulas
Solved
Jump to Solution
4022 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Bob_Scarborough
4 - Data Explorer
4 - Data Explorer

I’m using the following formula to take a record from one field to update a record in another field. 

IF({production Pipeline} = "Media Delivery", "Media Coordinator") & IF({production Pipeline} = "Ingest", "Media Coordinator") & IF({production Pipeline} = "Transcripts", {Assignee})

Now I’m writing a similar formula but the record has multiple selections and there are too many combinations to use the same formula, so rather than use “=” I would like to use “contain” but I can’t find a way to express contains.

I’m trying to get the formula to say  

IF({production Pipeline} CONTAINS "Transcripts", Assignee) 

Is there a work around for this

I tried “!=” and “>=” and “<=” that does not return the desired results

1 Solution

Accepted Solutions

that worked perfectly and will save me fa bunch of time. thank you so much

See Solution in Thread

3 Replies 3

Without seeing all the permutations, it’s hard to know which formula is the most appropriate for this, but try using IF(FIND(“Transcripts”, {production Pipeline}), Assignee) and see if that works?

Sho
11 - Venus
11 - Venus

contained can be expressed with the SEARCH function.
If contained, it returns 1 or more; if not contained, it returns empty.

that worked perfectly and will save me fa bunch of time. thank you so much