function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Priya MishraPriya 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 ))
Meghna Vijay 7Meghna Vijay 7
Hi Priya,

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