function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Asawari Kumbhalkar 4Asawari Kumbhalkar 4 

If the close date is not specified and status is ‘Closed-Filled’ or ‘Closed - Not Approved’ or ‘Closed - Canceled’ then error should be thrown as “Close date is not specified”.

CharuDuttCharuDutt
Hii Asawari
Try Below Validation 
AND(ISBLANK(Close_Date__c),OR(ISPICKVAL(Status,'Closed-Filled'),ISPICKVAL(Status,'Closed - Not Approved'),ISPICKVAL(Status,'Closed - Canceled')))
Please Mark It As Best Answer If It Helps
Thank You!
Maharajan CMaharajan C
Hi Asawari,

Small change in charu formula:

ClosedDate is standard field:
  
AND(ISBLANK(ClosedDate),OR(ISPICKVAL(Status,'Closed-Filled'),ISPICKVAL(Status,'Closed - Not Approved'),ISPICKVAL(Status,'Closed - Canceled')))

Thanks,
Maharajan.C