4

I am trying to either set up a field that will auto populate with parsed data from another or a workflow to accomplish the same.

I have text field of Field1_C with data 12345D. I would like to pull the first five digits (12345) and paste into Field2_C with "ABCDE" appended to the front. Result should look like "ABCDE12345".

Every formula I try says "Field1__C may not be used in this type of formula". Any help would be greatly appreciated.

6
  • Can you post the actual formula-- any version that you've tried so far? And what is the context of this formula?
    – sfdcfox
    Oct 11, 2013 at 15:44
  • Can you paste what formula(s) you have tried? This is a Workflow Field Update, and both Field1__c and Field2__c are on the same obect, and that object is selected for the field update, correct? Oct 11, 2013 at 15:46
  • 1
    Actually, I found my issue. I created Field2__C as a text field instead of formula. Once I realized my problem, end result formula was: "ABCDE"+(LEFT(Field1__c, 5)). Worked like a charm.
    – SDiv
    Oct 11, 2013 at 16:01
  • 5
    Can you post the problematic formula to your question, and the fixed formula as an answer so this question can be marked resolved and useful for others in the future? Oct 11, 2013 at 18:07
  • ca_peterson, the problematic formula was the same as I used above. The issue was that I was using the formula on a text field as a validation instead of creating proper WorkFlow Field Update as a Formula field.
    – SDiv
    Oct 12, 2013 at 22:35

1 Answer 1

-1

To help show there's an answer to your question, per the comments above, the source of the issue was that @SDiv was using the formula on a text field as a validation rule instead of creating a proper WorkFlow Field Update as a Formula field.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .