Skip to main content
Topics#Customer ServiceKim Weir 的问题
Kim Weir 提问于 #Customer Service
2016年8月8日 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 个回答
  1. Head In Cloud (Head In Cloud)
    2016年8月8日 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)

     

     
撰写回答...
0/9000