Skip to main content
Topics#Customer ServiceDomanda di Kim Weir
Kim Weir ha fatto una domanda in #Customer Service
8 ago 2016, 20:52

I am trying to create a formula field showing the current age of certain opportunites

I only want to include certain stages.  I created the following formula but keep getting a syntax error that is not specific enough for me to fix.  Can anyone help?  The error I am getting is Error: Syntax erros, Missing ')'

 

IF (((ISPICKVAL (StageName = "Nurturing", "Interested", "Considering POC", "POC Planned", "POC Active", "Negotiating")) (THEN TODAY() -  Start_Date__c)))

 

Thanks in advance.

 

 
3 risposte
  1. Head In Cloud (Head In Cloud)
    8 ago 2016, 21:01
    Hi Kim,

     

    Try this out

    IF(OR(ISPICKVAL(StageName, "Nurturing"), ISPICKVAL(StageName, "Interested"), ISPICKVAL(StageName, "Considering POC"), ISPICKVAL(StageName, "POC Active"), ISPICKVAL(StageName, "Negotiating"), ISPICKVAL(StageName, "POC Planned")) ,TODAY() -  Start_Date__c , 0)

     

     
Scrivi una risposta...
0/9000