I have previously written a validation rule associated with a checkbox and had success since it was simply a true/false scenario. However, I am presently trying to make certain fields required if another field is not blank. I'm getting syntax errors.
Here is what I attempted:
IF(NOT(ISBLANK( Asset_Number__c ))
OR))
ISBLANK( Asset_Manager__c ),
ISBLANK( Financial_Analyst__c ),
ISBLANK( Name ),
ISBLANK( Pledge_Investor__c )
)
)))
Thanks!
Shelby
2 个回答
Hi Shelby, Please try the below
AND(
NOT(ISBLANK( Asset_Number__c )),
OR(
ISBLANK( Asset_Manager__c ),
ISBLANK( Financial_Analyst__c ),
ISBLANK( Name ),
ISBLANK( Pledge_Investor__c )
)
)
Name is always a required field , I am not sure if you need that in the validation rule.
