Formula to allow duplicate

ilincach · 2024-01-25T10:07:12+00:00

There was an error rendering this rich post.

ilincach

Hello,

I am trying to make a formula in order to be able to create duplicate codes.

At the moment my formula goes like this:

IF Boolean THEN Concatenated Code ELSE Blank

And I want for my formula to do this :

IF my boolean is checked, then my formula should return the Concateneated Code but i want to allow a duplicate not blank. So if i check the same boxed every time, to be able to create duplicates.

At the moment, my formula doesnt create a duplicate.

Thanks

Accepted answers

All comments

Dikshant

@ilincach - Can you share screenshots of the data and how this logic is working at present? What is the formula for concatenated code, and what is your expected result?

ilincach

Hello here below the printscreen. Gebruik voor skill cluster is my boolean. The purpose is : when my boolean is checked, i should be allowed to create multiple cluster codes (which are a concatenation)

Dikshant

@ilincach

I would like to see the full data in grid view.

But based on the formula you shared, It is taking the values from the Concatenated Code line item from Total Item. And Concat Code Line Item has a summary as Last Non-Blank.

But what I think your requirement is that OTH08 List members which you mark as TRUE you want to concatenate those as comma separated and then show it in MAP01 Module like in this example since Code1 and Code3 has the Boolean as TRUE so in MAP01 Module you want to show Code1, Code3, but at present your formulas is showing Code3?

Let me know if I'm close to your requirement or you're expecting something else?

Thanks!

ilincach

I need to figure out a solution that generates a new code on each boolean selection, even if the selection is the same. So now, is using some pre-defined codes, but if i find a was to make a line item with a code generation, would be idealy

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…