I am trying to write a validation rule that would require a field to be completed if a stage level is selected AND from a date field meets a min requirement.
This is what I have so far but don't know how to include the date requirement AND ( OR ( ISPICKVAL(StageName, "5 - awarded"), ISPICKVAL(StageName, "4 - imminent"), ISPICKVAL(StageName, "3 - likely")) && ISBLANK( Validation__c ))
6 answers
Could you please give a try to the below formula
AND
(
CASE(StageName, '5 - awarded', 1, '4 - imminent', 1, '3 - likely', 1, 0) = 1 ,
Award_Date__c >= DATE(2022, 09, 30),
ISBLANK(Awarded__c)
)
