+ Start a Discussion
ElcalvoMikeElcalvoMike 

Using custom fields in custom field formulas

I feel like this should be pretty simple, yet I cannot get it to work.
 
I have a Job Description field (the API field name is Job_Description__c) and I want to create a short description with just the first 20 characters.
This field is populated from  a Web to Lead form.
so..
 
LEFT(Job_Description__c,20)
 
But the syntax error always comes up : Cannot find field Job_Description__c.
 
Can I not use a custom field in another custom field formula?
 
Mike
Jeff TalbotJeff Talbot
Description, long text area custom fields, & multi select picklists cannot be used in formula fields.
ElcalvoMikeElcalvoMike

Unfortunately, I cannot use any custom fields, regardless of thier type, in a formula of a new custom field.

Always get, Field does not exist.

See pic, Quantitiy__c is a Text 50 field and it doesn't work either.
JakesterJakester
Hi Mike,

Default value fields can't reference other fields on the same object. If you have Enterprise Edition or higher you could make a workflow that would automatically update this field when the record gets created and anytime the source field changes.
ElcalvoMikeElcalvoMike

Fantastic, just what I needed to know.

Will work on that!

 

Much appreciated.

 

Mike

 

justajaynejustajayne

Thanks Jakester!

 

You also helped answer part of my question as well :)

 

O' Happy Day

Thanks again

ElcalvoMikeElcalvoMike
Remember to activate your Workflow after creating it. Made that mistake.
justajaynejustajayne
will do thanks :)