Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Copying numbers inserted by Auto-Number
I want to be able to copy the numbers inserted by Auto-Number. I use them to create a control number for each row/record, which I want to then place in external systems for correlating notes and files.
However, the numbers inserted by Auto-Number don't seem to lend themselves to being copied once they've been created. I can't find a "copy" method that will allow me to copy it.
I also haven't found a way to replicate the contents in another column using formulas, which I had hoped would be in a form that does allow the contents to be copied.
The only method I found that works thus far is to create a Report that has that column's contents in it, which does allow the cell contents to be copied through normal procedures.
Another workaround I found is to copy and paste the number into a blank cell in another column, which can then be copied and pasted into another system, but that's a bit clunky.
Is there any other way to do this? The Report approach is not all that inefficient, and does save the need to use up a column of space in the main sheet, but it would be nice to know.