I have created a formula field on the custom object. I tried to create this formula:

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

where lead status is another formula field I created. The above gave me the error:

Error: Incorrect parameter type for function 'ISPICKVAL()'. Expected Picklist, received Text

How can this be rectified?

1 Answer 1


You can check equality with a single equals sign (=). For text formulas, this operator should suffice:

Lead_Status__c = "Admitted"

The double equals sign (==) will also work, and some may prefer that stylistically although I do not. From Formula Operators and Functions:

= and == (Equal)

Evaluates if two values are equivalent. The = and == operator are interchangeable.

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.