Good day,

We have a validation rule set up that does not allow a picklist field to go "backwards", and it only allows the system administrator profile to change the field. I would like to add another profile to the rule that can move the field "backwards" as well.

I added the second profile ID to the code, and it is giving me this error: Error: Syntax error. Missing ')'
What am I doing wrong?
 

IF (NOT ( ISPICKVAL(StageName__c, "Closed Lost")),
(
CASE(StageName__c , 
"Activity",1, 
"Application",2, 
"Decision",3, 
"Final",4, 
"Closed Lost",1,0) 
< 
CASE(PRIORVALUE(StageName__c) , 
"Activity",1, 
"Application",2, 
"Decision",3, 
"Final",4, 
"Closed Lost",1,0)
),False)
&& (NOT($User.ProfileId="00eE0000000v6Qq",$User.ProfileId="00eE0000000Nw8V"))

 

I am exploring the Lightning experience, and I'm wondering how to display one of our custom objects in the navigation menu on the left? We are currently using a custom object instead of Opportunities, so we will need easier access to it instead of opening it through the App Launcher Icon.

Is there a way to do this?

Good day,

We have a validation rule set up that does not allow a picklist field to go "backwards", and it only allows the system administrator profile to change the field. I would like to add another profile to the rule that can move the field "backwards" as well.

I added the second profile ID to the code, and it is giving me this error: Error: Syntax error. Missing ')'
What am I doing wrong?
 

IF (NOT ( ISPICKVAL(StageName__c, "Closed Lost")),
(
CASE(StageName__c , 
"Activity",1, 
"Application",2, 
"Decision",3, 
"Final",4, 
"Closed Lost",1,0) 
< 
CASE(PRIORVALUE(StageName__c) , 
"Activity",1, 
"Application",2, 
"Decision",3, 
"Final",4, 
"Closed Lost",1,0)
),False)
&& (NOT($User.ProfileId="00eE0000000v6Qq",$User.ProfileId="00eE0000000Nw8V"))