You need to sign in to do that
Don't have an account?
Anand Vijayakumar
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.