Skip to main content
Topics#Sales And MarketingFrage von Jen Cheng
Jen Cheng fragte in #Sales And Marketing
12. Juni 2013, 20:33

If field 1 has text, then field 2 = "Yes"

I've created the 1st field: 

 

Field 1 Label: Customer Engagement History

 

Field 1 API Name: Customer_Engagement_History_c

 

Data Type: Picklist

 

Picklist values: "ongoing sales deal", "recent audit"

 

Now, I want to create a 2nd field using a formula. So, if field 1 says "ongoing sales deal", then field 2  would say "Yes".

 

Field 2 Label: Customer Engagement History Met?

 

Field 2 API Name: Customer_Engagement_History_Met

 

Data Type: Formula

 

Here's my formula: 

 

if( ISPICKVAL(Customer_Engagement_History_c, "ongoing sales deal") ,"No", "Yes")

 

Here's what happens when i check the syntax:

 

 Error: Field Customer_Engagement_History_c does not exist. Check spelling

 

My "ispickval" refers back to the field 1 API name, why would i get an error saying it doesn't exist??

 

 

 

Thank you
3 Antworten
  1. Steve Molis (You Owe Me a Beer, Inc.)
    12. Juni 2013, 20:39
    +1 @Rhonda 

     

    Custom Fields end in double-underscore + lowercase c like this => TheFieldName__c

     

    yours is =>  Customer_Engagement_History_c

     

    +1 @Rhonda Custom Fields end in double-underscore + lowercase c like this => TheFieldName__c yours is => Customer_Engagement_History_c
Antwort schreiben...
0/9000