3

I want to create a formula field which fetches value from picklist field and display the value excluding parenthesis value.

For Example:- I have a picklist field with value: "Data(Matched)" Expected Value to Display on formula field is "Data".

Need to remove value which exists inside bracket and display on formula field

Can anyone help me on this.

2
  • how many values are there in picklist? If it is not more then you can go for CASE().
    – Anitha J J
    Oct 13, 2015 at 6:18
  • We have 100+ values in picklist Oct 13, 2015 at 6:26

1 Answer 1

3

You can use the string/text functions FIND and LEFT to do this.

use FIND to get the index of the left parenthesis and pass that to the LEFT function to return the characters upto that position.

something like this

LEFT(YourPickListField, FIND("(", YourPickListField) -1)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.