function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
MaheemSamMaheemSam 

Do not run the formula for specific profile

Hi,

  I want below formula not to run when system administrator logins but this is firing even when system admininstrator logins.  Please suggest me how to fix below issue.
AND ( 
NOT($Profile.Name <> "System Administrator"),
ISBLANK(TEXT(Partner_Information__c)), 
OR(
ISPICKVAL(StageName , "1 - Closed Won"),
ISPICKVAL(StageName , "2 - Contracts"),
ISPICKVAL(StageName , "3 - Proposal")
)
)
Thanks
Sudhir
 
Arpit Jain7Arpit Jain7
Hello Sudhir,

Can you please try below formula

AND ( 
($Profile.Name <> "System Administrator"),
ISBLANK(TEXT(Partner_Information__c)), 
OR(
ISPICKVAL(StageName , "1 - Closed Won"),
ISPICKVAL(StageName , "2 - Contracts"),
ISPICKVAL(StageName , "3 - Proposal")
)
)

Let me know for any issues.

Thanks
Arpit

 
Ajay K DubediAjay K Dubedi
Hi Sudhir,
You are just making a very small mistake.

You are using:-
NOT($Profile.Name <> "System Administrator")
It is negating your condition so instead, use this:-
 
$Profile.Name <> "System Administrator"
Please mark it as best if it helps.

Thanks
Ajay​
Fitzgerald AnukamFitzgerald Anukam
in your line 2, you should use either 
$Profile.Name <> "System Administrator"

or
NOT($Profile.Name = "System Administrator")

using NOT($Profile.Name <> "System Administrator") is interpreted as run for only System administrator.

Example:

$Profile.Name <> "System Administrator" means anyone that is not System administrator (i.e all other profiles).

NOT($Profile.Name <> "System Administrator") means Not(All other Profiles) which in this case is System Administrator.

That is why you formula isn't working.