You need to sign in to do that
Don't have an account?
Arjun y 7
I need to create a formula field for the below scenario
Hi All,
I need to create a formula field for the below scenario. I tried many ways to get the formula field.
Type Field contains two values. Those are
1.ASD8765
2.OPDQ76YTH
If Type field begins with 'A', the formula field should store the first 4 characters of the string as Formula field ='ASD8'
If Type field begins with 'O', the formual field should store the first 3 charaters of the string as Fomula field = 'OPD'
Can any one help me to solve this.
Thank You!!
Arjun
I need to create a formula field for the below scenario. I tried many ways to get the formula field.
Type Field contains two values. Those are
1.ASD8765
2.OPDQ76YTH
If Type field begins with 'A', the formula field should store the first 4 characters of the string as Formula field ='ASD8'
If Type field begins with 'O', the formual field should store the first 3 charaters of the string as Fomula field = 'OPD'
Can any one help me to solve this.
Thank You!!
Arjun
Please check below updated code.
If the Type will start with 'A', It will take first 4 char of type and will populate on Formula field
If the Type will start with 'O', It will take first 3 char of type and will populate on Formula field
Please let me know if its works for you.
Thanks,
Prem Anandh
All Answers
Please check with below code.
Formula Field:
Screen-shot:
Please let me know incase any queries
Thanks,
Prem Anandh
Thank You!!
It is not a Picklist value.. It is a Text field.
Thanks for the response!!
Please check below updated code.
If the Type will start with 'A', It will take first 4 char of type and will populate on Formula field
If the Type will start with 'O', It will take first 3 char of type and will populate on Formula field
Please let me know if its works for you.
Thanks,
Prem Anandh