Create a distinct code for each row


Hi! For each row in my sheet, I'm looking to add a formula that creates a distinct number based on the data in a barcode column.

It's almost the same idea as an auto-number row, but it also counts for duplicates. So if the data in the the barcode column is repeated, the number in my "helper" column is repeated also. I would like for the number to start in 0001 and then keep adding +1 as the rows are added. What I found in the community are more like count formulas, and none actually creating a sequential number. Here's a screenshot what I would like to see in the sheet:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!