Skip to main content
Question

Formula Field-Multi Select Text

  • October 19, 2020
  • 0 replies
  • 133 views
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
------------------------------
This topic has been closed for replies.

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
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement