You need to sign in to do that
Don't have an account?
Ab
Formula field to have only first two digits of text field
Hello,
I have a text field which has postal code.
I want to create another text field with only first two digits of the postal code.
I want to use this field to group in Reports.
Will i be able to group in report witha formula field.
I have a text field which has postal code.
I want to create another text field with only first two digits of the postal code.
I want to use this field to group in Reports.
Will i be able to group in report witha formula field.
LEFT(text, num_chars)
so LEFT(TEXTFIELD__c, 2)
thx
All Answers
LEFT(text, num_chars)
so LEFT(TEXTFIELD__c, 2)
thx
Formula fields update themselves, they don't update other fields.
As a common practice, if your question is answered, please choose 1 best answer.
But you can give every answer a thumb up if that answer is helpful to you.
Thanks