Auto number column type and copy rows workflow

Haley S

I have two sheets that utilize the auto number column for tracking two different things. sheet two has all of the data sheet one has, including the ID that is autogenerated on sheet one (manual input into sheet two), but it also has additional columns such as the autogenerated sheet two ID. I wanted to create a workflow that copies a row from sheet one into sheet two every time a new row is added. This piece is easy, however, when the workflow is triggered, it sees that both sheets utilize an auto number column type. Although the two columns are named differently, it adds the auto number from sheet one into the auto number column for sheet two, regardless of if the number has been used already in sheet two. This totally negates the point of having an auto number column to maintain a unique id. Does anyone have any work arounds? I would love for Smartsheet to address this as I'm not sure a work around exists.

Note: A report will not work as a work around. The data from sheet one has to be in sheet 2.

ker9

@Haley S

You might up vote this enhancement request (sorry I don't have a better answer)

https://community.smartsheet.com/discussion/102520/multiple-auto-number-columns-in-one-sheet

Tiffany Castro

This is the exact same problem I am having now…trying to find a work around with no luck.

suzanne.fitzpatrick88451

Have you tried using Data Mesh? It seems like if you were to map the fields you want moved over to sheet 2, that should move the data you want moved. If you decide you want to add in the auto numbering from sheet 1 to sheet 2, you should be able to set up a separate field in sheet 2 that is set to text (not auto numbering) and map it to that auto numbering field from sheet 1. You should be able to still have an auto numbering column in sheet 2, you just wouldn't have it mapped to/from anything in sheet 1.