Formula to allow duplicate
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.