You need to sign in to do that
Don't have an account?
Salesforce seekar
Validation rule : If a user logging with salerep profile , in Opportunity , stage picklist he should be unable to select a value called Needs Analysis.
Hi ALL ,
If a user logging with salerep profile , in Opportunity , stage picklist he should be unable to select a value called Needs Analysis.
please correct my rule :
AND
( $Profile.Name = "Sales Profile" &&
Not(
ISPICKVAL(StageName, "Needs Analysis")
)
)
If a user logging with salerep profile , in Opportunity , stage picklist he should be unable to select a value called Needs Analysis.
please correct my rule :
AND
( $Profile.Name = "Sales Profile" &&
Not(
ISPICKVAL(StageName, "Needs Analysis")
)
)
Please find the below formula,
AND(ISCHANGED(StageName), TEXT(StageName) = 'Needs Analysis', $Profile.Name = 'Sales Profile')
Thanks,
Vinoth
All Answers
Please find the below formula,
AND(ISCHANGED(StageName), TEXT(StageName) = 'Needs Analysis', $Profile.Name = 'Sales Profile')
Thanks,
Vinoth
Please use this formula
AND(
ISCHANGED( StageName ), ISPICKVAL(StageName , 'Needs Analysis'),$Profile.Name = 'Sales Profile'
)
Thanks
Anupama
with your answer , sales guy is able to change the stage of opty picklist . it is not throwing any error .
question :
while logginginto sales profile as a test user , if i change the stage of an opportunty to
'Needs Analysis' , it should throw an error as "Sales guy cannot put the stage picklist as Needs Analysis"
Could you try the below one,
AND(TEXT(StageName) = 'Needs Analysis', $Profile.Name = 'Sales Profile')
I have tested the below validation rule,
AND(ISCHANGED(StageName), TEXT(StageName) = 'Needs Analysis', $Profile.Name = 'Sales Profile')
This validation rule doesn't alllow the user with profile 'Sales Profile' to Change the picklist value from anyother value to 'Needs Analysis'.
And, if already value of StageName is 'Needs Analysis' and user do not make any change in the StageName or if user changes the StageName into anyother value except 'Needs Analysis', it will allow the user to Save the record.
May I know in which case, this validation rule does not throw an error?
Thanks,
Vinoth
Thanks for Replying ......... Validation rule is working . thanks alot