I am trying to build a cross object formulae on a custom object X from a standard object.

I am trying to use the formulae (Patient__r.Status)on a formulae field where status is a picklist field on the standard object. it shows me the error that

Error: Field Status is a picklist field. Picklist fields are only supported in certain functions.

How can I remove this error?

  • can you post your formula code here Jan 9 '17 at 23:30
  • @Santanu Boral Patient__r.Status Jan 9 '17 at 23:33
  • 4
    If you need to access a value from picklist, use the following: TEXT(Patient__r.Status)
    – o-lexi
    Jan 9 '17 at 23:34
  • Thanks @Oleksiy: This solved my issue. I was able to replicate this on a formulae field and populate it on the custom object. Using this formulae field i am trying to write another validation : AND(ISCHANGED(Final_Result__c ), ISPICKVAL(Lead_Status__c, "Admitted")) where lead status is the formulae field which i had created, it gave me the error "Error: Incorrect parameter type for function 'ISPICKVAL()'. Expected Picklist, received Text". how can this be rectified Jan 9 '17 at 23:52
  • 2
    N.B. formulae is plural of formula
    – cropredy
    Jan 10 '17 at 0:36

Your formula should be something like this -

AND(ISCHANGED(Final_Result__c ), Lead_Status__c = "Admitted")

  • you don't need == for comparison in formula, just a single =, in opposite to Apex
    – o-lexi
    Jan 10 '17 at 17:20
  • Apologies! Updated! Jan 10 '17 at 17:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.