function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jennifer ThomasJennifer Thomas 

Formula syntax help on a VR

Hello, 

I'm am struggling with a Vaildation Rule and really need some help! Please!  No syntax issues, it just doesn't work the way I need it to.
When I go to test the rule, if I select a from the picklist a single field System__c, "Axis360"), the rule fires and requires me to enter a value on 3 customer fields Device__c, Browser__c and Format_Reader__c. 

I'm not sure how to fix this. Hope this makes sense to someone.  Thanks in advance for any assistance


(ISBLANK(TEXT( Device__c ))) ||
(ISBLANK(TEXT( Browser__c ))) ||
(ISBLANK(TEXT( Format_Reader__c ))) ||

(ISPICKVAL ( System__c, "Axis360") &&
ISPICKVAL(Status, "Closed")) &&


ISPICKVAL( Case_Type_PS__c ,"Issue Axis 360") &&

( ( ISPICKVAL(Case_Sub_Type__c , "Error Message") &&
( ISPICKVAL (CS_Category__c,"Initial Setup") ||
ISPICKVAL (CS_Category__c,"Account/Profile") ||
ISPICKVAL (CS_Category__c,"Ordering") ||
ISPICKVAL (CS_Category__c,"Login/Password") ||
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
) ||

( ISPICKVAL(Case_Sub_Type__c , "Error-Failed") &&
( ISPICKVAL (CS_Category__c,"Initial Setup") ||
ISPICKVAL (CS_Category__c,"Account/Profile") ||
ISPICKVAL (CS_Category__c,"Ordering") ||
ISPICKVAL (CS_Category__c,"Login/Password") ||
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
) ||

( ( ISPICKVAL (Case_Sub_Type__c , "Title Not on Patron Bookshelf") ||
ISPICKVAL (Case_Sub_Type__c , "Unable to Open/Play") ||
ISPICKVAL (Case_Sub_Type__c , "Compatibility") ) &&
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
)
Best Answer chosen by Jennifer Thomas
MagulanDuraipandianMagulanDuraipandian
AND(
NOT(ISBLANK(System__c)), ISBLANK(Browser__c) , ISBLANK(Format_Reader__c)
)

If this solves your problem, kindly mark it as the best answer.

Regards,
Magulan
http://www.infallibletechie.com

All Answers

MagulanDuraipandianMagulanDuraipandian
AND(
NOT(ISBLANK(System__c)), ISBLANK(Browser__c) , ISBLANK(Format_Reader__c)
)

If this solves your problem, kindly mark it as the best answer.

Regards,
Magulan
http://www.infallibletechie.com
This was selected as the best answer
Jennifer ThomasJennifer Thomas
Thank you! That did the trick.