Skip to main content

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

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?

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

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?


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

Reply


Terms & Conditions