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 – Santanu Boral Jan 9 '17 at 23:30
  • @Santanu Boral Patient__r.Status – kunal gupta 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 – kunal gupta 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")

| improve this answer | |
  • 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! – Nikhil Khivansara 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.