Hello Everyone,
Need help on the validation rule which I have written, but for some reason it is not working as per the need.
This rule was written so that any Originating Business Unit if it is "HGS Digital" there is a picklist Field called "HGS Digital Service Offering". So once the Opportunity is saved in Stage 4&5 this field should be mandatory.
Now, here is the issue if someone is not selecting any option from the HGS Digital Service Offering it is giving an error but the problem is even if they are selecting the option still it is throwing the same error.
AND(
ISPICKVAL(Originating_Business_Unit__c,"HGS Digital"),
OR(
ISBLANK(TEXT(Element_Service_Offerings__c)),
OR(
ISPICKVAL( StageName , "Stage 4 and 5 – Solution and Pricing"),
ISPICKVAL( StageName , "Stage 6 - Clarify"),
ISPICKVAL( StageName , "Stage 7 - Negotiate"),
ISPICKVAL( StageName, "Stage 8 - Contract"),
ISPICKVAL( StageName , "Stage 9 - Closed - Won"))
)
)
Can someone please help me on this, any lead will be highly appreciated.
Thanks
Rovil
8 answers
Oh, never mind, I get it.
Try this:
AND(
ISPICKVAL(Originating_Business_Unit__c,"HGS Digital"),
ISBLANK(TEXT(Element_Service_Offerings__c)),
OR(
ISPICKVAL( StageName , "Stage 4 and 5 – Solution and Pricing"),
ISPICKVAL( StageName , "Stage 6 - Clarify"),
ISPICKVAL( StageName , "Stage 7 - Negotiate"),
ISPICKVAL( StageName, "Stage 8 - Contract"),
ISPICKVAL( StageName , "Stage 9 - Closed - Won")
)
)
