IfElse Formula help

Hi Phuong Trinh . I have never tried formula on a multienum field before, maybe the error you are facing is due the way multienum values are set. try that instead:

ifElse(equal($statut_prospect_c,""),"^^","^ACHAT^")

Hi André Lopes i've tried your formula, but it still doesn't work  I've received the same message box : The formula must be of typeboolean

In which module do you want to implement that formula?

And how are the fields defined?

Is the name of the field status... or statut...?

Which field is the multiselect field and how is the dropdown defined?

AND in which language did you use the studio formula editor?

Hi Phuong Trinh ,

Multiselect fields do not have an option in Studio to set the field as a calculated field. Based on the error message you are receiving, it seems like you are trying to put the formula in the 'Required If' or 'Read Only If' formula options since those options require a boolean outcome. If you are looking to set the multiselect field based on another field value, your best option in terms of native Sugar functionality is to use SugarBPM.

Chris