Hi,
I am trying to create a module (line item) from a list formatted as boolean.
Does Anaplan have a built in contain function so that I can select the words that I want ?
i.e. if column 1 contains "SKY" then TRUE else FALSE
Thank you!!
What I think you want is the FIND function: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/FIND.html. If the text is found, then it returns the character number where it starts otherwise it returns 0. You could set up a formula like FIND ("SKY", 'Column 1') > 0 to generate the TRUE/FALSE output if the item is found.
There was an error rendering this rich post.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
