+ Start a Discussion
Terry_0101Terry_0101 

How to enforce a date value if another field has data?

Requirement is:
If a "Payment Made" field has a number in it, then do not allow the "Project Date" to be blank.  Here is what I have but not working.

AND( 
TEXT(Payment_Made__c) = "", 
ISBLANK(Project_Date__c))
Best Answer chosen by Terry_0101
YuchenYuchen
You can try the following formula:
AND(NOT(ISBLANK(Payment_Made__c)), ISBLANK(Project_Date__c))

This assumes the Payment Made field is a number field, and if it has data then the Project Date cannot be blank.

All Answers

YuchenYuchen
You can try the following formula:
AND(NOT(ISBLANK(Payment_Made__c)), ISBLANK(Project_Date__c))

This assumes the Payment Made field is a number field, and if it has data then the Project Date cannot be blank.
This was selected as the best answer
Terry_0101Terry_0101
Perfect!  Thanks!