Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
5 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
5 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
5 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
------------------------------
  • KarenHenke's avatar
    KarenHenke
    Qrew Cadet
    5 years ago

    That worked perfectly!!! 

    I am literally in tears right now - this is such a relief!! I can't thank you enough!!



    ------------------------------
    Karen Henke
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      I'm a sucker for QB brainteasers .. glad you are happy.

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