Forum Discussion

GunshamLakhiani's avatar
GunshamLakhiani
Qrew Cadet
5 years ago

Formula Field-Multi Select Text

Hi,

I have created a formula field which is of type multi select text. The formula is working fine but when i am selecting this field in the report selection as ask the user it shows as a plain text box and does not show as a multi select drop down to select the options.

Below is the formula which i have used in this field

Split(List(" ; ",
If( = true,"A"),
If (= false, "B"),
If ([ROption] = "A","Yes")
))

Can anyone help to find out why it does not display as a drop down?

Regards
Gunsham


------------------------------
Gunsham Lakhiani
------------------------------
Formulas and functions

3 Replies

  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    A formula field cannot be used as a drop-down. Formulas - no matter the type - only produce an output as determined by the formula you've created.

    ------------------------------
    Blake Harrison
    [email protected]
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • GunshamLakhiani's avatar
      GunshamLakhiani
      Qrew Cadet
      5 years ago
      Hi Blake,

      If that is the case then what will be use of this Multi Select Field and where and how it can be used?


      Regards
      Gunsham

      ------------------------------
      Gunsham Lakhiani
      ------------------------------