You need to sign in to do that
Don't have an account?
Michael 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")
IF (Status = "Approved"
&& CreatedBy.Profile_Name__c = "IGTD Coronary Area Manager"
&& CreatedBy.UserType = "Hospital")
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