Help: Converting a line item text to list

Highlighted
New Contributor

Help: Converting a line item text to list

Hello, On the level 1 modelling exam I am getting stuck with a error when trying to convert a text line item to a list. Has anyone had similar error or know how to resolve? Many Thanks in advance!

 

 

 

  Capture1.PNG

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Help: Converting a line item text to list

@mrahma16 

 

In order to convert Text Formatted Line item into List Formatted Line item we use FINDITEM function

 

Line item 1 - Formatted as Text

Line item 2 - FINDITEM(List 1, Line item 1)

 

Here List 1 is the name of the list from where you want to check if the text in Line item 1 matches any item in List 1

 

Hope that helps

Misbah