• JaxBeach
  • NEWBIE
  • 10 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 17
    Questions
  • 35
    Replies
Hi,

I need to send out time triggered email alerts on cases that haven't received an email response.  Does anyone know how I would code that - I would base it on createdDate but I don't know how to create a formula for email received equals zero.

thanks.

I have a text field that is actually for a date, but they only want Year/Month - how can I ensure that the date gets entered as yyyy/mm (all numeric)?

 

Thanks so much :)

Hi,  I have a really long formula and I need it to NOT look at account record type names that contain "International"  How can I add that to the existing formula below?

 

IF (ISPICKVAL(Channel__c , "Commercial") && ShippingState<>NULL && CONTAINS ("AK:AZ:CA:CO:HI:ID:MT:NV:NM:OR:UT:WA:WY", ShippingState), "Commercial Central/West",
IF (ISPICKVAL(Channel__c , "Commercial") && ShippingState<>NULL && CONTAINS ("ND:SD:MN:WI:MO", ShippingState), "Commercial North Central",
IF(ISPICKVAL(Channel__c, "Commercial") && ShippingState <>NULL && CONTAINS("TX,AR,LA,OK", ShippingState), "Commercial TALO",
IF (ISPICKVAL(Channel__c , "Commercial") && ShippingState <>NULL && CONTAINS ("NE:KY:KS:MI:IA:IL:IN:OH", ShippingState), "Commercial Midwest",
IF (ISPICKVAL(Channel__c , "Commercial") && ShippingState <>NULL && CONTAINS ("ME:CT:DE:FL:MD:MA:WV:NH:NJ:NY:PA:RI:VT:VA:DC", ShippingState), "Commercial East",
IF (ISPICKVAL(Channel__c , "Commercial") && ShippingState <> NULL && CONTAINS ("NC:SC", ShippingState), "Commercial NC/SC",
IF (ISPICKVAL(Channel__c , "Commercial") && ShippingState <>NULL && CONTAINS ("TN:GA:AL:MS", ShippingState), "Commercial South East",
IF(ISPICKVAL(Channel__c, "Forensics") && ShippingState <>NULL && CONTAINS("AK:AZ:CA:CO:HI:ID:MT:NV:NM:OR:UT:WA:WY:ND:SD:NE:KS:OK:TX:MN:IA:MO:AR:IL:WI:MI", ShippingState), "Forensics - West",

IF(ISPICKVAL(Channel__c, "Forensics") && ShippingState <> NULL && CONTAINS("LA:MS:TN:KY:IN:OH:AL:CT:DC:DE:FL:GA:ME:MA:MD:NH:NJ:NY:NC:PA:RI:SC:VT:VA:WV:PR", ShippingState), "Forensics - East",
IF(OR (ISPICKVAL(Channel__c , "Domestic"),ISPICKVAL(Channel__c , "Government"))&& ShippingState <>NULL && CONTAINS ("AK:AZ:CA:CO:HI:ID:MT:NV:NM:OR:UT:WA:WY", ShippingState), "LE West",
IF(OR (ISPICKVAL(Channel__c , "Domestic"),ISPICKVAL(Channel__c , "Government"))&& ShippingState <>NULL && CONTAINS ("CT:DC:DE:FL:GA:ME:MA:MD:NH:NJ:NY:NC:PA:RI:SC:VT:VA:WV:PR", ShippingState), "LE East",
IF(OR (ISPICKVAL(Channel__c , "Domestic"),ISPICKVAL(Channel__c , "Government"))&& ShippingState <>NULL && CONTAINS ("AL:AR:IL:IN:IA:KS:KY:LA:MI:MN:MS:MO:NE:ND:OH:OK:SD:TN:TX:WI", ShippingState), "LE Central", NULL))))))))))))

 

 

THANKS!

Hi,

 

I have a formula that makes a field required if certain requirements are met.  I found out that it is effecting older cases where this new field wasn't active yet.

 

How do I put a qualifier on the formula so that it only applies to cases created after 6/30/2103?

 

My formula is

 

AND(ISPICKVAL( Product_Category__c , "Defense Technology"), TEXT(Order_Contains_ATF_Items__c)="") && $RecordType.Name = "Customer Care" &&  ISPICKVAL(Case_Type__c , "Place an Order") && ISPICKVAL(Status, "Closed")&& CreateDate < 2013-06-30T00:00:00.000Z

 

My error message states Error: Syntax error. Extra T00:00:00.000Z

 

 

Thanks. :)

Hi,  i'm trying to download a force.com app called case detachifier from the app exchange.  It states I need to install it from the providers site but when I click on that button, the resulting URL   http://xifier.com/CaseDetachifierSetup.exe  states cannot display the web page.  I've tried this in both firefox and IE.  Curious thing is on the download stats on the home page it shows it being downloaded, but maybe that considers it downloaded when you click on the install from provider's site.  I didn't see anywhere where I could contact someone at the app exchange or force.com and not sure if service support would cover this issue by submitting a ticket.  Any help would be greatly appreciated.  We are over our storage limit and need to find a way to archive attachments.

Earlier we fixed the beginning part of my formula and it is now working for commercial channels (not listed).  When I run it for Domestic or Government channels it just assigns all of them to LE West - can anyone tell why from what is listed below?

 

Thanks so much for your help with this.

 

 

IF (ISPICKVAL(Channel__c , "Domestic") || ISPICKVAL(Channel__c , "Government") && CONTAINS ("AK:AZ:CA:CO:HI:ID:KS:MT:NV:NM:OR:UT:WA:WY", ShippingState), "LE West",

IF (ISPICKVAL(Channel__c , "Domestic") || ISPICKVAL(Channel__c , "Government") && CONTAINS ("CT:DC:DE:FL:GA:ME:MA:MD:NH:NJ:NY:NC:PA:RI:SC:VT:VA:WV:PR", ShippingState), "LE East",

IF (ISPICKVAL(Channel__c , "Domestic") || ISPICKVAL(Channel__c , "Government") && CONTAINS ("AL:AR:IL:IN:IA:KS:KY:LA:MI:MN:MS:MO:NE:ND:OH:OK:SD:TN:TX:WI", ShippingState), "LE Central", NULL))))))))))))

Hi,  this is the first portion of my formula that updates a sales region field based on states and distribution channel.  When I run it, it updates all of the commercial channel accounts with the first IF statement value of "Commercial Central/West"  I can't figure out why it isn't reading or looking at the other if statements.  I didn't get any limitation or syntax errors when I created it.

 

IF (ISPICKVAL(Channel__c , "Commercial") && NOT(CONTAINS ( ShippingState , "AK:AZ:CA:CO:HI:ID:MT:NV:NM:OR:UT:WA:WY")), "Commercial Central/West",
IF (ISPICKVAL(Channel__c , "Commercial") && NOT(CONTAINS ( ShippingState , "ND:SD:MN:WI:MO")), "Commercial North Central",
IF(ISPICKVAL(Channel__c, "Commercial") && NOT(CONTAINS(ShippingState, "TX,AR,LA,OK")), "Commercial TALO",
IF (ISPICKVAL(Channel__c , "Commercial") && NOT(CONTAINS ( ShippingState , "NE:KY:KS:MI:IA:IL:IN:OH")), "Commercial Midwest",
IF (ISPICKVAL(Channel__c , "Commercial") && NOT(CONTAINS ( ShippingState , "ME:CT:DE:FL:MD:MA:WV:NH:NJ:NY:PA:RI:VT:VA:DC")), "Commercial East",
IF (ISPICKVAL(Channel__c , "Commercial") && NOT(CONTAINS ( ShippingState , "NC:SC")), "Commercial NC/SC",
IF (ISPICKVAL(Channel__c , "Commercial") && NOT(CONTAINS ( ShippingState , "TN:GA:AL:MS")), "Commercial South East",
IF(ISPICKVAL(Channel__c, "Forensics") && NOT(CONTAINS(ShippingState,

Hi, 

 

I have two custom objects - one parent (BVP), one child (BVP Awards) in master detail relationship.

 

The child object lists amounts of government funded awards based on calendar year

I would like to update the parent record with the $ amounts from the year that matches the current year.

 

I've got the BVP Awards as Ojbect and the field to update on BVP Object - field is total proposed amount, but I'm not sure how to create a formula that says if the year field equals the current year, update the total proppsed amount from that record.  Does that make sense? 

 

Ex. 

 

# 001      2012         $11,356.68  Update this amount from record #001.

#002      2011         $15,752.36

 

 

Thanks.

Ok, so I'm totally making this up as I go along, but am terrible with syntax and can't figure out how to do it.

 

IF(Account_Manager__c = "Erik Belsom" || "Darin Fulks" || "Joe Reynolds" || "Kevin Degel" || "Mike Reichenbach" || "Shawn Mayfield" || "Ted Drysdale" || "Shannon Couch", "Central",
IF(Account_Manager__c = "Frank Harden" || "Jennifer Johnson" || "Mary Bateman" || "Rick Beaman" || "Tim Boyle", "West",
IF(Account_Manager__c = "Bill Lacaillade" || "David Pennington" || "Dominick Provisiero" || "Howard Johnson" || "Jacques Shelton" || "Kevin Boucher" || "Mark Brown" || "Joe Reynolds" || "Stacey Petyak" || "Tom Bracy" || "Travis Cronk" || "Nicholas Gorsky","East", null
)
)
)

I'm trying to return a region area if the field contains any of the listed names - we have 3 different regions.  It was expecting a boolean and received text - sorry I don't my my boolean from my ......

Hi,

 

We had a formula on the lead page that calculates the aging of the lead

 

IF ( D2subD1__c > 0,
TEXT(FLOOR( D2subD1__c )) & " days ","" )

 

However, it never stops aging even after the lead has been approved.  How can we stop the field from aging when the lead status field is updated to Approved?  Thanks.