+ Start a Discussion
lincylincy 

Formula not working as expected

I have a check box field Type__c which is by default checked and if user tries to un check that then comments__c field should me required and it should bypass if the opportunity type is close/closedwon/new.i have written like this but am confused how to add opportunity type to this condition

AND(
Typr__c,
 ISBLANK( Comments__c) 
VinayVinay (Salesforce Developers) 
Hi Lincy,

Try below snippet 
 
AND(Type__c = false, ISBLANK(comments__c ), (OR(ISPICKVAL(opportunity type, 'Closed Won'),ISPICKVAL(opportunity type, 'Close'),ISPICKVAL(opportunity type, 'New') )))

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar
Maharajan CMaharajan C
Hi,

Try the below formula:

AND(
Type__c = false, 
ISBLANK(comments__c), 
NOT(OR(ISPICKVAL(Type, 'Closed Won'),ISPICKVAL(Type, 'Close'),ISPICKVAL(Type, 'New') ))
)

In above formula confirm the opportunity type field api name.  if it is oppotunity standard type field then leave it.

Thanks,
Maharajan.C