Skip to main content
Hi Everyone,

 

I need to put a validation rule on opportunity object.

 

The error condition would be: if you are not the admin and finance profile it is not possible to demote stages 9, 10, 11, 12 and 13.

 

Thanks a lot for your help,

 

Best Regards

 

Delphine
8 answers
  1. Apr 22, 2020, 1:30 PM
    Hi Delphine,

     

    You may try below formula in validation rule:

     

    AND(

     

    ISCHANGED(StageName),

     

    OR(

     

    ISPICKVAL(StageName, '9'),

     

    ISPICKVAL(StageName, '10'),

     

    ISPICKVAL(StageName, '11'),

     

    ISPICKVAL(StageName, '12'),

     

    ISPICKVAL(StageName, '13')

     

    ),

     

    ($Profile.Name <> 'System Administrator'),

     

    ($Profile.Name <> 'Finance User')

     

    )

     

    Note: You need to change filed Name and values as per your Org Settings