AND (
NOT
(ISPICKVAL( Stage_at_Loss__c , "")),
(
OR
(ISPICKVAL( StageName, "Closed Lost"),
ISPICKVAL( StageName, "Abandoned"))
)
)
Hello all!
I want a picklist to be required if our Stage picklist equals "Closed Lost" or "Abandoned". Above is the code I thought would work, and it does, but not in the way I want it to. It will required our "Stage at Loss" picklist to be required under the given parameters, but it won't let you save the Opportunity. You have to move it to another stage, edit the Opportunity, and then move it back.
This is prolly a fairly common newbie question, but I need to find out how I can make a checkbox required if a value from a custom picklist is specified using validation rules.
Basically, I have a checkbox called "Pre_Traffic_IPID_c" and a picklist called "Tier_I_Site_c". I want to make it so that when a BD rep selects value=YES from "Tier_I_Site_c", the checkbox "Pre_Traffic_IPID_c" becomes required.
Here is the formula I am trying to use, but it doesn't seem to work:
AND ( Pre_Traffic_IPID__c , ISPICKVAL( Tier_I_Site__c , "YES"))
Can someone please give me a hand? (I suck at these things right now, so any and all help would be greatly appreciated)
