Text formatted line item duplication

Rajasekhar

Hi,

I have a line item which is text formatted. User enters values like Apple, mango and apple again.

For the 3rd value(apple)- it should show me an msg pop up, that it exists already.

Please can anyone help me on how to write logic for line item 2.

Regards,

Rajasekhar

Accepted answers

ChrisAHeathcote

@Rajasekhar

The simplest approach here is to use the FINDITEM function.

This takes a text formatted line item and then searchs a list for that Item.

If the list item corresponding to the text is present in the list it will return that list item.

Use this following link to the Anapedia page to go through the steps involved in setting this up

FINDITEM Link

If you still need to show the 'Exist,' or 'New' message you can use the following formula,

=IF NOT ISBLANK(FINDITEM(List, Text formatted line item)) THEN Exist ELSE New

Ensure that your target line item (line item 2) is formatted as text as the answer to this formula is text formatted.

Chris

All comments

Puneeth H P

Hi @Rajasekhar

You can achieve this .

use ISFIRSTOCCURENCE function here .

here create a line item which is Boolean formatted (Check) .

'Check' - Formula would be ISFIRSTOCCURENCE(Line Item 1, List) - List here is which is showed in picture having List Item 1 ,Item 2....

Here the boolean will be true only for Item which is given only once and first .

And you create a Comment Line item (text formatted) - 'Line Item 2' and write a formula :

IF Check is FALSE then "Already Existed" ELSE "New" .

Hope this helps . Happy Anaplan!

Thanks,

Puneeth HP

ChrisAHeathcote

@Rajasekhar

The simplest approach here is to use the FINDITEM function.

This takes a text formatted line item and then searchs a list for that Item.

If the list item corresponding to the text is present in the list it will return that list item.

Use this following link to the Anapedia page to go through the steps involved in setting this up

FINDITEM Link

If you still need to show the 'Exist,' or 'New' message you can use the following formula,

=IF NOT ISBLANK(FINDITEM(List, Text formatted line item)) THEN Exist ELSE New

Ensure that your target line item (line item 2) is formatted as text as the answer to this formula is text formatted.

Chris

Rajasekhar

Thank you so much.

Rajasekhar

Thank you so much.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…