0

In salesforce I have written the formula field, but its not saving/working properly.

If Completed_Date__c != null && Completed_Date__c < Deadline__c then Compliant else Violated

IF((NOT(ISBLANK(Completed_Date__c))) <  Deadline__c , 'Compliant', 'Violated')

If Completed_Date__c not populated then field should show blank.

  • Did you try treat blank as null in formula – Tushar Sharma Dec 6 '17 at 8:20
1

Please try this formula.

   IF( 
ISBLANK(Completed_Date__c),' ', 
IF( 
Completed_Date__c< Deadline__c , 
'Compliant', 
'Violated' 
))
  • Thanks ! How can we check if both the Completed_Date__c != null && Deadline__c != null in the above formula field ? – Sayali Shinde Dec 6 '17 at 18:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.