You need to sign in to do that
Don't have an account?
lincy
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)
AND(
Typr__c,
ISBLANK( Comments__c)
Try below snippet
Hope above information was helpful.
Please mark as Best Answer so that it can help others in the future.
Thanks,
Vinay Kumar
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