Could you please help me to write a rule with a couple of IF arguments?
I already have 1 in place: IF( TEXT( Status ) <> "Open", ISBLANK( Campaign__c ) , null).
Now I want to add that this rule is not applicable to some of the users (I will need to use User Name because there is no way to distinguish them by Role etc.). And there will be 3 of them.
Thanks in advance!!!
4 risposte
Sure thing! At first create a New Formula Field on the User Object which will concatenate the FirstName and LastName. Here you go:
- Go to Setup | Customize | Users | Fields
- Click New
- Select the Data Type as Formula
- Name it as: FullName
- The Formula Return Type will be: TEXT
- Formula :
FirstName + ' ' + LastName
- You need not add it to the Page Layout
- Save it
Now your Validation Rule will be:
AND(
TEXT(Status) <> 'Open',
$User.FullName__c <> 'Name of the First Person',
$User.FullName__c <> 'Name of the Second Person',
$User.FullName__c <> 'Name of the Third Person',
ISBLANK(Campaign__c)
)
