Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Operator for Contains

Topic Labels: Formulas
Solved
Jump to Solution
2516 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