You need to sign in to do that
Don't have an account?
Supriyo Ghosh 5
Add constant in a formula field
HI,
I want to copy one custom fields value to another custom fileds with a suffix value.For example
Code = 65892001
I want to put one A before this number and save it to another filed.(Like New code = A65892001).Is it possible??
I want to copy one custom fields value to another custom fileds with a suffix value.For example
Code = 65892001
I want to put one A before this number and save it to another filed.(Like New code = A65892001).Is it possible??
You can create a formula field as 'Suffix'+TEXT(Customfield1)
Step1. Create a custom field say constant with (number as datatype.)
step2.create formula field say suffix (text as return data type)
in the formula field suffix write below code
Please accept my solution as Best Answer if my reply was helpful. It will make it available for other as the proper solution. If you felt I went above and beyond, you can give me kudos.
Thanks and Regards
Sandhya