Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
3 years ago

Multi-Select Text Operators

I have a summary field (Multi-select text) in a table.  I then want to create another Formula Multi-Select Text field based on the summary Field.  I basically want to do something like the below, but not sure what the proper operators are for TextList fields

Split(List(";",
If([Channel Summary] = "Retail Sales and Distibution"), "Retail"),
If (Contains([Channel Summary],"Retail Sales and Distribution", "Tech Care - Mobility"), "Omni")
If(Does not contain([Channel Summary], "Retail Sales and Distribution", "Centers"))

I know how the Contains works but i'm not sure how to write "equals" or "does not contain"

Thanks,

Michael

------------------------------
MICHAEL SARGENT
------------------------------

1 Reply

  • Hi Michael:
    For doesn't contain you can use
    If(Contains([Channel Summary], "Retail Sales and Distribution")=false, "some value")


    Formula for  Formula Multi Select Text Field:
    Split(
    If([Channel Summary] = "Retail Sales and Distribution"), "Retail")&";"&

    If (Contains([Channel Summary], "Retail Sales and Distribution") or
    Contains([Channel Summary], "Tech Care - Mobility") , "Omni", )&";"&


    If(Contains([Channel Summary], "Retail Sales and Distribution")=false, "some value"),
    ";")

    I hope this helps :)

    ------------------------------
    Razi D.
    Desta Tech LLC
    razi@destatechs.com
    ------------------------------