Skip to main content
Question

Multi-Select Text Operators

  • April 29, 2022
  • 0 replies
  • 30 views

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
------------------------------
This topic has been closed for replies.

RaziD
Forum|alt.badge.img+3
  • Registered
  • May 1, 2022
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
------------------------------