• ajw
  • 0 Points
  • Member since 2013

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1

We have a custom object lookup field (RF_Reseller__c) in our opportunities that defines what company is handling the opp.  What I want to do is create a formula field that outputs "Direct sale" when the lookup field has our company name in it, and "Indirect sale" when it's any other value (i.e. our resellers).


What I've got is


IF(CONTAINS(RF_Reseller__c , "ABC Co."), "Direct Sale", "Indirect Sale")


I get no syntax errors, but every opp comes back with the false value (Indirect sale), even when the lookup field is "ABC Co." with case-sensitivity taken into account.


Any idea how I can get a simple IF like this to return a certain text value based on the value in a lookup field?



Message Edited by tomc1227 on 02-05-2009 04:52 PM