Using IF and AND

Question

I'm trying to write a validation rule that:

IF the "Uninterested" box is checked

AND

"Uninterested Details" is blank

The user sees an error that tells them they have to put details in the details field. I've tried a few iterations of this and I'm constantly seeing either "Extra ")"" or "Extra AND" and I can't figure out why this formula is being such a hassle. Here's what I'm currently staring at:

IF (Uninterested__c, "True", "False") AND ISBLANK( Uninterested_Details__c )

Where am I stumbling here? #Validation Formula

Keiji Otsubo · Accepted Answer

Hi Victoria,   Try this   AND( Uninterested__c, ISBLANK( Uninterested_Details__c ) )

Keiji Otsubo · Answer

Hi Victoria,    When thinking about the formulas in validation rules, I think you should always write the conditions that will be True. I was taught that.   Also, Uninterested__c is a checkbox, so this alone is true or false. IF (Uninterested__c, "True", "False")  --> Uninterested__c   AND () and &&, OR () and || are the same, but I like AND (), OR () because I want to clarify the scope of influence. Affects only in parentheses.   Perhaps && works instead of AND. IF (Uninterested__c, "True", "False")   &&  ISBLANK( Uninterested_Details__c )

Using IF and AND

Formulas

関連学習

さらにヘルプを表示