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
The NewbieThe Newbie 

Need help with Lookup validation for a custom object

I have two fields in the custom object which is Contractor and Expo Contact, These fields are required before closing

Status - Status__c (Should be Monitioring)
Contractor - contractor__c (Lookup Account)
Expo Contact - Expo_Contact__c (Lookup Contact)
AnkaiahAnkaiah (Salesforce Developers) 
Hi,

try with below formula code. 
AND(ISPICKVAL(Status__c,'Closed'), ISBLANCK(Expo_Contact__c),ISBLANCK(contractor__c))
If this helps, Please mark it as best answer.

Thanks!!