Account.Name + " - " +
IF(ISPICKVAL(Deal_Type__c, "Monthly"),"M2M",
If(ISPICKVAL(Deal_Type__c, "Annual Prepaid"),"Annual",
If(ISPICKVAL(Deal_Type__c, "Quarterly"),"Quarterly",
If(ISPICKVAL(Deal_Type__c, "Semi-Annual"),"Semi-Annual","Other"))
+ " - " +
TEXT(YEAR( CloseDate )) + IF(Not(ISBLANK(Opp_Name_Details__c))," - (" + Opp_Name_Details__c + ")","")))
The formula works if I select Deal Type as Quarterly, Semi-Annual, but if I select Deal type as Monthly, or Annual. the Year Text and the Opp name details field do not populate on the opp name.
Any ideas why that would be the case?
7 个回答
Can you duble check that you don't have duplicate WFR running?
Also can you post the complete Formula and a screenshot of the WFR and the Field Update Action?
