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 risposte
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