Skip to main content
Topics#Data ManagementSara Monksfield의 질문
Sara Monksfield (RSC) 님이 #Data Management에 질문했습니다
2019년 5월 22일 오전 9:40

Notification when Opportunity date changes from another value - how to stop this firing on first entry?

What's the formula to send an email when a date field is changed from one date to another, but not when the field is first entered (i.e. changed from blank to not blank)?

 

I've tried this but it still fires the email when you first populate the date:

 

AND(

 

NOT (ISNEW ()),

 

ISCHANGED(([Opportunity].Requested_Trial_Start_Date__c )))

 

 
답변 10개
  1. Amnon Kruvi (The Architech Club)
    2019년 5월 22일 오전 10:14
    Hi Sara, 

     

    Let's try this:

    AND(
    NOT (ISBLANK (PRIORVALUE([Opportunity].Requested_Trial_Start_Date__c ))),
    ISCHANGED(([Opportunity].Requested_Trial_Start_Date__c )))

     

     
답변을 작성하세요...
0/9000