Operator for Contains

Question

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

Best answer by Bob_Scarborough

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

Bob_Scarborough · Accepted Answer

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

pressGO_design · Answer

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

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded