Hi,
I have tried to simplify a list by splitting into two picklists where I want to substitute the word Customer for the actual customer name, rather than having a 400 deep picklist, I can have 40.
E.g. Customer Rocks is selected in A1, the name of the customer ("Harry") is in B1. In C1 you substitute the word customer with the customer name in B1. C1 would therefore be "Harry Rocks".
Within my picklist I also have words in front of "Customer", and therefore I can't just replace by place value.
A1= Customer Rocks
A2= New Customer submission
B1 = Harry
B2 = Harry
C1 = Harry Rocks
C2 = New Harry submission
Is there a way to do this?
Bookmarks