Apex Code Development You need to sign in to do that
Don't have an account?
knichols formula
Can someone help me on this? We need to have multiple 'owners' of a record for reporting so we added 4 additional fields but we want to make sure if that person is already entered into one of the fields they can't be entered again. This works except that the fields are blank...which my formula assumes they're equal. Here's my formula:
OR( OwnerId == Owner_2__c, OwnerId == Owner_3__c, OwnerId == Owner_4__c, OwnerId == Owner_5__c, Owner_2__c==Owner_3__c, Owner_2__c==Owner_4__c, Owner_2__c==Owner_5__c, Owner_3__c==Owner_4__c, Owner_3__c==Owner_5__c, Owner_4__c==Owner_5__c )
Hi,
Add additional checks for null.
OR(
...
AND(Owner_2__c != null, OwnerId == Owner_2__c)
...
)
Regards,
Arun