function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
knicholsknichols 

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
)
 
 
 


arunkarunk
Hi,
 
 
Add additional checks for null.
OR( 
... 
AND(Owner_2__c != null, OwnerId == Owner_2__c) 
...
) 
 
Regards,
Arun  
Message Edited by arunk on  10-20-2009 12:32 AM