• DNears
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

I need help with a ISPICKVAL formula. 

 

I have a Picklist field named Type_Client_1.  If Type_Client_1= Seller, then the word "Buyer" should display.  If Type_Client_1= Buyer, then the word "Seller" should display. Please help me to correct my formula (see below.

 

WRONG FORMULA:

 

if ( ISPICKVAL( ( Type_Contractor_1__c ) , "Seller"), "Buyer",
if ( ISPICKVAL( (Type_Contractor_1__c) , "Buyer")), "Seller"))

 

Thank you in advance for your time and assistance.

 

Regards, DNears

  • January 22, 2009
  • Like
  • 0