You need to sign in to do that
Don't have an account?
GMASJ
Pick List Validation to be selected based on the specified value in validation
Hi,
In pick list Oppty_Reg_Extension_Request__c there are two values
1. 1st 90 Days Extension
2. 2nd 90 Days Extension
User should be able to select first 1st 90 Days Extension and save only after than he should be able to select 2nd 90 Days Extension
Please let me know how to add this condition in formula.
Thanks
Sudhir
In pick list Oppty_Reg_Extension_Request__c there are two values
1. 1st 90 Days Extension
2. 2nd 90 Days Extension
User should be able to select first 1st 90 Days Extension and save only after than he should be able to select 2nd 90 Days Extension
Please let me know how to add this condition in formula.
Thanks
Sudhir
Try this validation rule:-
OR(AND(ISNEW(),ISPICKVAL(Picklist__c,"2nd 90 Days Extension")),
AND(ISCHANGED(Picklist__c),ISPICKVAL(PRIORVALUE( Picklist__c),""), ISPICKVAL(Picklist__c,"2nd 90 Days Extension")))
Thanks
Anil.B
All Answers
Try this validation rule:-
OR(AND(ISNEW(),ISPICKVAL(Picklist__c,"2nd 90 Days Extension")),
AND(ISCHANGED(Picklist__c),ISPICKVAL(PRIORVALUE( Picklist__c),""), ISPICKVAL(Picklist__c,"2nd 90 Days Extension")))
Thanks
Anil.B
Thanks for you reply I just need to add one more condition to this formula
This validation should not be fired for Opportunity Owner and profile with Administrator Please suggest me how to add this condition.
Thanks
Sudhir
Thanks
Sudhir