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!
@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
Check out the latest Anaplan feature updates and enhancements in our February 2026 official release notes. There you'll find information on: User Experience Board Insights Panel Management Reporting on mobile Custom action buttons on mobile Modeling experience Four digit calendar Forecaster Holiday calendars UX pages…
Check out the latest Anaplan feature updates and enhancements in our January 2026 official release notes. The information below offers supplemental information to that post. Dataspaces in Anaplan Data Orchestrator Dataspaces are partitioned areas of a tenant-wide Anaplan Data Orchestrator instance. Integration…
