• Haaris
  • NEWBIE
  • 0 Points
  • Member since 2019
  • SFDC Developer

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
Hi All,

i need to create a formula or Rule criteria when the case is created with perticular conditions:

Case Record Type ='abc'
Category='abc'
Case Origin='abc'
Ischanged Reason For Negotiation
Ischanged Negotiated/Extended Due Date
When all the condition true then email should trigger 
i created below formuala but having error.

AND(( ISPICKVAL(WCT_Category__c , 'Learning: Customer Relationship Management (CRM)') ,OR(ISCHANGED( WCT_Reason_For_Negotiation__c ),ISCHANGED( WCT_Negotiated_Due_Date__c )))OR( ISPICKVAL( Origin , 'US Advisory Learning'),ISPICKVAL( Gen_RecordType__c , 'Learning - Delivery R&F Advisory')))

Regards,
Priya Mishra
Hello,

I have this validation rule the Case object that I don't know why it does not work:

AND(Account.RecordType.DeveloperName <> "Customer", Owner:Queue.QueueName  <> "Case_Inspection_US")

Scenario:
Allow re-assigning case to a "non-Customer" Account Record Type if Case Owner is Case_Inspection_US. Otherwise, block the change.

So I have case owned by Case Inspection US and I try to change the account to a non-Customer record type and the validation rule triggers.  It should allow it.

It looks like the AND() is not working right.  What am I doing wrong?  Thanks.