Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 28, 2023 03:29 PM
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
Solved! Go to Solution.
Jun 29, 2023 07:24 AM
Jun 28, 2023 04:22 PM
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?
Jun 28, 2023 05:13 PM
contained can be expressed with the SEARCH function.
If contained, it returns 1 or more; if not contained, it returns empty.
Jun 29, 2023 07:24 AM
that worked perfectly and will save me fa bunch of time. thank you so much