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.

Improve this question
6
  • Can you post the actual formula-- any version that you've tried so far? And what is the context of this formula?
    – sfdcfox ♦
    Commented 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?
    – Thomas Taylor
    Commented 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
    Commented 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?
    – ca_peterson
    Commented 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
    Commented Oct 12, 2013 at 22:35

1 Answer 1

Reset to default
-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.

Improve this answer

You must log in to answer this question.

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