Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
6 years ago

Brain Teaser: Translating data from a multi-select text field to formula text field

Hello, I'm going to to my best to explain a super complicated situation :) I'm hoping one of you brilliant people can help me. There are values in Field A that I need translated (for lack of a bet...
Formulas and functions
Tables and fields
KarenHenke's avatar
KarenHenke
Qrew Cadet
6 years ago
Thank you Mark!
When I try this formula, the first comma after "Dog" is highlighted with an error that says "Expecting )"

Would love your thoughts on how to fix that.

------------------------------
Karen Henke
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Right, it was expecting more brackets

fix fix this part here to add three missing  ),  one on each line 

List(";",
IF(Contains($MultiInTextFormat, "Dog"), "Poodle;Yorkie;Doberman"),
IF(Contains($MultiInTextFormat, "Cat"), "Tabby;Siamese"),
IF(Contains($MultiInTextFormat, "Turtle"), "Box"))




------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------