You need to sign in to do that
Don't have an account?
![Anand Vijayakumar Anand Vijayakumar](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Workflow formula error
Hello,
I'm trying to implement a workflow that would trigger if a custom picklist field value related to contacts is selected, 'W9'.
This is the formula I have, and I'm getting the error that I've entered an Incorrect parameter type for function 'TEXT()', but I don't see an option within formula operators that would apply to alphanumeric strings . . . here is what I have:
AND
(TEXT(EnrollmentrxRx__Active_Enrollment_Opportunity__r.Integration_Applicant_Type__c)='W9',
ISBLANK(TEXT(EnrollmentrxRx__Active_Enrollment_Opportunity__r.Integration_Applicant_Type__c)) )
I'm trying to implement a workflow that would trigger if a custom picklist field value related to contacts is selected, 'W9'.
This is the formula I have, and I'm getting the error that I've entered an Incorrect parameter type for function 'TEXT()', but I don't see an option within formula operators that would apply to alphanumeric strings . . . here is what I have:
AND
(TEXT(EnrollmentrxRx__Active_Enrollment_Opportunity__r.Integration_Applicant_Type__c)='W9',
ISBLANK(TEXT(EnrollmentrxRx__Active_Enrollment_Opportunity__r.Integration_Applicant_Type__c)) )
For picklist type fields use should is ISPICKVAL() function. Use below code
Thanks,
Jitendra Kawale.