You need to sign in to do that
Don't have an account?
Mohan Raj 33
here I want the validation rule for when I select the Opportunity itself on the "stage" piclist value is selected in any one of "Closed Won " or "Closed Lost" then the value of the particular opportunity is not changed(that stage field in the "Closed Won" to Other(Closed Lost also) or "Closed Lost" to Other(Closed Won also) ) before. Here I tried as well as I know in the validation rule for the task but It's gives the error by followingly, "Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.".So please help me to complete ths task.For answers thanks in advance.
validation rule is not working. Why ?
IF( ISPICKVAL( StageName , "Closed Won") || ISPICKVAL( StageName, "Closed Lost" ) , PRIORVALUE( StageName ) , PRIORVALUE( NOT ( StageName ) ) )
here I want the validation rule for when I select the Opportunity itself on the "stage" piclist value is selected in any one of "Closed Won " or "Closed Lost" then the value of the particular opportunity is not changed(that stage field in the "Closed Won" to Other(Closed Lost also) or "Closed Lost" to Other(Closed Won also) ) before. Here I tried as well as I know in the validation rule for the task but It's gives the error by followingly, "Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.".So please help me to complete ths task.For answers thanks in advance.
Use below update code,
Hope this will help you.
Mark it solved if works for you.
Thanks
karthik
All Answers
And clearly explain your task , so that I will help you to solve it
if (stage == "closed Won" or "closed Lost"){
it's not changed any other in the stage field piclist options (including the closed won to closed lost also not possible in this condition)
else(other all valuesin the stage field are chenges to another one in the list of piclist (Note:here also if changed the another value into closed won or closed lost after it's not changeble));}
I want the opportunity stage is in never changeble once it's to be set the value of "closed Won" and "Closed Lost ".
Then the Other all stage items are changeble to one to another(as normal).
If I selected to the other one to closed won or closed lost it's also maintain on the constant after it's set to be a "closed won" or "closed lost".
If I try to change the stage value "closed won" or "closd lost" to another it's provide a error message.I think now you are clear undertand my task I hope.Thank you, Mohan
I want the opportunity stage is in never changeble once it's to be set the value of "closed Won" and "Closed Lost ".
Then the Other all stage items are changeble to one to another(as normal).
If I selected to the other one to closed won or closed lost it's also maintain on the constant after it's set to be a "closed won" or "closed lost".
If I try to change the stage value "closed won" or "closd lost" to another it's provide a error message.I think now you are clear undertand my task I hope.Thank you, Mohan
Try this
if its failing let me know which condition its failing,
its works makr it solved..
Thanks
karthik
BUT IN HERE WHAT IS THE PROBLEM MEANS once I try to change the "closed won" stage to same closed won stage it's also produce the error(It's also same as in the "closed Lost" case once I try to change the value to "closed lost" to again "closed lost" it's also provide the error).so please try to rectify this error only.
It's a problem in this code instand of this it produce all the output correctly.Thank you, Mohan
Use below update code,
Hope this will help you.
Mark it solved if works for you.
Thanks
karthik
I am facing the same issue can you please suggest me.
Regards,
Soundar.