0

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?

Improve this question
6
  • can you post your formula code here
    – Santanu Boral
    Commented Jan 9, 2017 at 23:30
  • @Santanu Boral Patient__r.Status
    – kunal gupta
    Commented Jan 9, 2017 at 23:33
  • 4
    If you need to access a value from picklist, use the following: TEXT(Patient__r.Status)
    – o-lexi
    Commented Jan 9, 2017 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
    Commented Jan 9, 2017 at 23:52
  • 2
    N.B. formulae is plural of formula
    – cropredy
    Commented Jan 10, 2017 at 0:36

1 Answer 1

Reset to default
1

Your formula should be something like this -

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

Improve this answer
2
  • you don't need == for comparison in formula, just a single =, in opposite to Apex
    – o-lexi
    Commented Jan 10, 2017 at 17:20
  • Apologies! Updated!
    – Nikhil Khivansara
    Commented Jan 10, 2017 at 17:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .