I am trying to create a validation rule so that if a date/time field on a lead is either blank or in the past And if the lead status picklist field equals "Appointment Set" then a validation rule error would appear.
When I save a record with the lead status of "Appointment Set" and leave the Appointment Date field blank the system lets me save a record without any error message appearing.
Here is what my validation rule formula looks like
(Appointment_Date__c < NOW() || ISBLANK( Appointment_Date__c )) &&
(ISPICKVAL( Status , "Appointment Set"))