Skip to main content
Topics#FormulasReinhard Ndlovu's Question
Reinhard Ndlovu (Fidelity Investments) asked in #Formulas
Sep 9, 2022, 6:13 PM

Trying to get a decaying lead score and nest in a decaying score to it as well. I keep getting this error - Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4

IF( TEXT( LeadSource )="Event", 50, 0, IF(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +30, 37.5, IF(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +60, 25,  IF(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +120, 0, 0))))   

 If I add AND to the formula this is what it gives me - Error: Syntax error. Missing ')'. IF I add those it just shifts to another error.  IF( TEXT( LeadSource )="Event", 50, 0, IF(AND(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +30, 37.5, IF(AND(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +60, 25,  IF(AND(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +120, 0, 0)))))

#Formulas  #Collaboration

1 answer
  1. Keiji Otsubo
    Sep 12, 2022, 9:35 PM

    Hi @Reinhard Ndlovu ,

     

    I think the syntax error will go away. However, I'm not sure what this formula means.

     

    This part doesn't always work

    Are you mistaken for today?

     

    Last_Activity_Date__c  > Last_Activity_Date__c +30

     

    IF( TEXT( LeadSource )="Event", 50, 
    IF(AND(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +30), 37.5, 
    IF(AND(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +60), 25,  
    IF(AND(TEXT( LeadSource )="Event", Last_Activity_Date__c  > Last_Activity_Date__c +120), 0,
    0))))
Write an answer...
0/9000