You need to sign in to do that
Don't have an account?
Richard Jones 17
or: Incorrect number of parameters for function 'if()'. Expected 3, received 1
Why would i be geting this message from :
IF(opp__c>0,"RE",if((( LastActivityDate ) - (DATE(2013,12,19)))<365)&&(of_Lost_Opps__c >0),"Lead",IF(Last_Activity_Date__c ="","CA"))
IF(opp__c>0,"RE",if((( LastActivityDate ) - (DATE(2013,12,19)))<365)&&(of_Lost_Opps__c >0),"Lead",IF(Last_Activity_Date__c ="","CA"))
I took a stab at your formula and came up with the following. Note, that I added "SOME_DEFAULT_VALUE" as I'm not sure what the default should be in that case.