You need to sign in to do that
Don't have an account?
jisaac
Validation rule requiring a picklist field to be completed based on another Picklist field value
Not sure why this Validation rule is not working. I want to make sure that they enter the name of the Alliance Manager if the BU Opportunity Type is "Referral to Third Party Vendor" but it is not working.
Here is the formula:
AND
(ISPICKVAL( BUOpportunityType__c , "Referral to Third Party Vendor"),
ISPICKVAL( Alliance_Manager__c, " " ) )
Any ideas?
Here you go Jane ;-)
So yours would be :
I noticed that your formula had a blank space " " between your quotes, if you're checking for a blank picklist you have to use just double quotes with nothing inbetween "".
Also, when writing a VR for a Picklist you need to make sure that the picklist values in your formula match the ones in the Picklist EXACTLY (spelling, punctuation, Upper/Lower Case, blank spaces, etc.)
All Answers
May be you need to re-phrase the formula.
I wrote the following and it worked:-
if( ISPICKVAL(ForecastCategoryName, "Pipeline") , if(ISPICKVAL( LeadSource, "") ,true,false),false)
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
Here you go Jane ;-)
So yours would be :
I noticed that your formula had a blank space " " between your quotes, if you're checking for a blank picklist you have to use just double quotes with nothing inbetween "".
Also, when writing a VR for a Picklist you need to make sure that the picklist values in your formula match the ones in the Picklist EXACTLY (spelling, punctuation, Upper/Lower Case, blank spaces, etc.)