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
Go to Solution.
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.