Salesforce Developer Community

Barb Rheaume @ MTS
NEWBIE
0 Points
Member since 2004

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
0

Questions
3

Replies

Formula Field Broken

This doesn't recognize the close date filter. Can someone help?

IF( RecordTypeId ="0123000000004s7" ,null,IF(AND( Amount <>0,CloseDate > (2009-03-31)),".6",JP_Points_1__c + JP_Points_2__c + JP_Points_3__c))

kstites1
August 18, 2009
Like
0

7 replies

I am trying to create a formula that looks up the User object "Division" field value (based on case owner) so I can group by the division field on a case activity report. So far, I have been unable to do this. Does anyone have any ideas?

Foster
January 10, 2009
Like
0

3 replies

Need help on Custom Formula

I am trying to input the below code on Custom Formula, but getting Error.

CASE( Status ,
"Open - Not Contacted","Open - Not Contacted",
"Working - Contacted","Working - Contacted",
"Open- In Approval","Open- In Approval",
"Channel Deal Approved (Converted)", "Channel Deal Approved (Converted)",
"Closed - Converted","Closed - Converted",
"Closed - Not Converted","Closed - Not Converted",
"Closed - Not Converted","Closed - Not Converted",
"Ready to Convert","Ready to Convert",
null)

Can any one help on the same?

mansurie786
December 19, 2008
Like
0

Formula Field Broken

Lookup formula to User object

Need help on Custom Formula