Formula to get a Line Item formatted as a List based on a Trimmed data field
I am importing data with a field that has the names trimmed from a list. What formula can I use so that that rediscovered name corresponds to the name of the list in Anaplan?.
Let me try to show this example:
Data TXT File:
|Crititcal Line Abrev Field:|
|Critical Line List:|
|Credit and Income|
What formula I need to use to create a Line Item formatted as a List [Critical Line List] based on Crititcal Line Abrev Field?.
Thanks a lot for any recommendation.