+ Start a Discussion
Brandon NelsonBrandon Nelson 

AND Formula Not Working

Can anyone look at this and tell me why this is NOT prompting the validation rule to fire?
The rule says, IF first field = x and the second field = NULL, then fire rule.
 
AND(ISPICKVAL(Sales_Status__c, "Startup (pre-startup meeting)"),
Startup_Meeting_Date__c = NULL)

 
Maharajan CMaharajan C
Hi Brandon,

Try the below formula:

AND(TEXT(Sales_Status__c) = "Startup (pre-startup meeting)",
ISBLANK( Startup_Meeting_Date__c ))

Thanks,
Maharajan.C
kaushal sharma 24kaushal sharma 24
AND(TEXT(Sales_Status__c) = "Startup (pre-startup meeting)",
ISBLANK( Startup_Meeting_Date__c ))

9xmovies (https://realtimenews.org.in/9xmovies/)