+ Start a Discussion
Michael McClearnMichael McClearn 

FieldStatus is a picklist Field. Picklist fields are only supported in certain functions.

Hi, I am trying to set a workflow rule that fires when three of the custom fields on my custom object avaluate as true. This is the formula as I have it now, but I keep recieiving the above error message whenever I check the syntax. Any help would be greatly appreciated.

 IF (Status = "Approved"
&& CreatedBy.Profile_Name__c = "IGTD Coronary Area Manager"
&& CreatedBy.UserType = "Hospital")
SATHISH REDDY.SATHISH REDDY.
Hi there,

I see that the way you have your logic is incorrect. Please go through this one https://developer.salesforce.com/forums/?id=906F00000008xCSIAY
If your field api names are correct then your formula should be something in the lines as below. Please double check you api names.
AND(
          ISPICKVAL(Status, 'Approved'),            
          Profile_Name__c = 'IGTD Coronary Area Manager',
          UserType__c = 'Hospital'
)

Please mark it as the best answer if this helps.

Cheers!
Sathish