MICHAELSARGENT
3 years agoQrew Cadet
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
------------------------------
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
------------------------------