You need to sign in to do that
Don't have an account?
Priya Mishra
workflow email alert
i have list of fields to check the condition using formual to send a email. i have created the below formula to send email every time when the WCT_Reason_For_Negotiation__c and WCT_Negotiated_Due_Date__c is getting changed but if the value is null it should not send the email can you plase help me out what is missing in this.
AND( ISPICKVAL( WCT_Category__c ,'Learning: Customer Relationship Management (CRM)') ,
ISPICKVAL( Origin ,'US Advisory Learning'), RecordType.Name ='Learning - Delivery R&F Advisory', ISCHANGED(WCT_Negotiated_Due_Date__c ),ISCHANGED(WCT_Reason_For_Negotiation__c ))
AND( ISPICKVAL( WCT_Category__c ,'Learning: Customer Relationship Management (CRM)') ,
ISPICKVAL( Origin ,'US Advisory Learning'), RecordType.Name ='Learning - Delivery R&F Advisory', ISCHANGED(WCT_Negotiated_Due_Date__c ),ISCHANGED(WCT_Reason_For_Negotiation__c ))
Try this :-
AND( ISPICKVAL( WCT_Category__c ,'Learning: Customer Relationship Management (CRM)') ,
ISPICKVAL( Origin ,'US Advisory Learning'), RecordType.Name ='Learning - Delivery R&F Advisory', ISCHANGED(WCT_Negotiated_Due_Date__c ),ISCHANGED(WCT_Reason_For_Negotiation__c ), NOT(ISNULL(WCT_Negotiated_Due_Date__c)), NOT(ISNULL(WCT_Reason_For_Negotiation__c)))
Hope it helps, if it does mark it as solved.
Thanks