Hi All ,
I am would like to create a validation rule for certain users, that will only allow negative values in a number fields.
Please let me know if you have an idea .
Thanks in advance ,
best
4 Antworten
Your validation rule has an error, if you want to add more conditions you simply add a comma and add your condition in the AND
AND($Profile.Name <> "Standard User" , field__c >=0, ISPICKVAL(Contract_Status__c, "Activated")
this will trigger if the 3 conditions are true (negative, and the profile is the same as mentioned and the picklist value is Activated), It depends on the logic you want to implement to choose between OR and AND
PS: don't forget to change the field and profil names to correct ones.
