Sign Up ›

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

Need Help with a ISPICKVAL Formula

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

Steve :-/Steve :-/
I think you might wanna get rid of your second "IF" statement
wgrawgra

You may try it with a CASE formula:

 

CASE(Type_Contractor_1__c,"Seller","Seller","Buyer","Buyer","")

 

Cheers,

 

Werner

JakesterJakester
Just a friendly suggestion to use the (now very hidden) Insert Code button when sharing code snippets. This will stop the obnoxious behavior of changing text into smiley faces. The Insert Code button is between the icon of the clipboard with a blue "W" and the striked-through ABC icon.
Steve :-/Steve :-/

I think you want a formula something like this:

 

CASE( Type_Contractor_1__c,
"Seller", "Buyer",
"Buyer" , "Seller",
NULL)
 
 
 
Message Edited by Stevemo on  01-28-2010 12:48 PM