Need help with Validation Rule

Question

I have to write a validation rule on the standard object 'TASK' . If the picklist value of the 'Subject' field is 'Status Update' then the 'Description' field should not have any value. I am trying to write the rule but always I am getting the below error.

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

Below is my Validation Rule.

AND(ISPICKVAL( Subject , "Status Update") ,  NOT( Description = NULL ) )

Please help me in knowing where I am going wrong.

Thanks!

Answer 1

Try this

AND(Subject="Status Update",NOT(Description=NULL))

It is working fine

Hope this helps...

Answer 2

Your Subject field might be of Text data type, while ISPICKVAL() works on picklist data types. To check text field, you can use TEXT() method. The below validation rule should work fine -

AND(TEXT(Subject) = "Status Update", NOT(Description=NULL))