Auto increment samples number with sub-samples

Question

Good morning,I am quite new sharepoint user and I would need that my list generate automatically a incremental A-number to identify samples but with the option of sub-samples.So if the "letter" column will be empty the list will generate consecutive number, but if there is a letter, the list will repeat the new number with a letter.For example:Sample&nbsp; &nbsp; &nbsp; &nbsp; Letter&nbsp; &nbsp; &nbsp; &nbsp; OutputA1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;A2A3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A3aA3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A3bA3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A3cA4A5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A5aA5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A5bA6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A6aA6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A6betc...Thank you in advance.

anthony_tudor · Answer

Hi fabiogiallo it's not exactly what your after, but you could do something similar to this which I wrote about creating an auto ID column and extend it to output the values you are after: https://wp.me/p9ToOl-jP

Let me know if it works for you!

fabiogiallo · Answer

Anthony_Tudor&nbsp; thanks for your answer, but it just does part of what i need (and i can do this already using calculated columns)

Forum Discussion

Auto increment samples number with sub-samples

Share

Resources