You need to sign in to do that
Don't have an account?
Eric Willig
Can I create a custom formula field that searches for text contained in another text field (not a picklist)?
Can I create a custom formula field that searches for text contained in another text field (not a picklist)? We have a custom text field in our acount records that contains a long string of text (list of products that are updated in batch each night).
I would like to create a sperate field that indicates if the first text field has 1 of 6 different words in it (they are specific products).
I can do this easily in excel but cannot figure out how to do it here. The Contains argument is only for a picklist, yes? Thanks, in advance, for you input.
I would like to create a sperate field that indicates if the first text field has 1 of 6 different words in it (they are specific products).
I can do this easily in excel but cannot figure out how to do it here. The Contains argument is only for a picklist, yes? Thanks, in advance, for you input.
if it works, please mark as best response!
May the force.com be with you
All Answers
if it works, please mark as best response!
May the force.com be with you