You need to sign in to do that
Don't have an account?
Glenn Nyhan 54
Picklist Formula for a Workflow Rule Not Functioning Error Message: Error: Incorrect number of parameters for function 'ISPICKVAL()' Expected 2, received 3
I've created a formula for a Workflow Rule to Update a field value. But I get and error message: Error: Incorrect number of parameters for function 'ISPICKVAL()' Expected 2, received 3
I don't seem able to correct this. Anyone have any ideas?
I don't seem able to correct this. Anyone have any ideas?
As Niraj mentioned, you cannot give more than 2 parameters for ISPICKVAL. If you have to check for the "Annual Check/Cash" condition, you can add another ISPICKVAL in your OR function. And addign to it, after closing your OR function you need to provide the field update.
I hope the below code should work.
IF(
OR(
ISPICKVAL(Payment_Channel__c, "Click and Pledge"),
ISPICKVAL(npe01_Membership_Origin__c, "Annual"),
ISPICKVAL(npe01_Membership_Origin__c, "Annual Cash/Check")),
Membership_End_Date_Less_30_Days__c = TODAY() , "false condition" )
All Answers
IF( ISPICKVAL( StageName,"Needs Analysis") || ISPICKVAL( StageName,"closed lost"), TODAY(), TODAY() +2)
In 2nd ISPICKVAL(), you are giving three parameters. Where as it accept only 2 as you have mentioned in your 1st ISPICKVAL.
Just remove 2nd/3rd parameter from 2nd ISPICKVAL, as per your matching "npe01_Membership_Origin__c" field value.
Might be it will help you.
As Niraj mentioned, you cannot give more than 2 parameters for ISPICKVAL. If you have to check for the "Annual Check/Cash" condition, you can add another ISPICKVAL in your OR function. And addign to it, after closing your OR function you need to provide the field update.
I hope the below code should work.
IF(
OR(
ISPICKVAL(Payment_Channel__c, "Click and Pledge"),
ISPICKVAL(npe01_Membership_Origin__c, "Annual"),
ISPICKVAL(npe01_Membership_Origin__c, "Annual Cash/Check")),
Membership_End_Date_Less_30_Days__c = TODAY() , "false condition" )