Copy row (using Automation) not copying auto-number field

Jeana

I have a source sheet that generates an auto-number (Asset Number) when a new row is added (via a form). My automation workflow copies the row to another sheet but doesn't bring over the auto-number? I even added a condition on the automation to make sure the auto-number was not blank before the copy?

Should this be working or is it a limitation of Smartsheet? If it's a limitation or known issue any alternative solutions out there?

Jeana

Paul Newcome

Ok. Lets try this...

Add a text/number column to the source sheet. Enter this...

=[Asset Number]@row

This will pull the data into a column that is NOT system generated.

See if that text/number column copies over.

Paul Newcome

Finally!! Happy to help! 👍️

Paul Newcome

Try adding in a checkbox field. In this field enter a formula of

=IF([Asset Number]@row <> "", 1)

This will check the box as soon as the number s populated.

Then you can set up your automation to run with the trigger being that the box is checked.

Jeana

Thanks Paul. Good idea but it didn't work. Copied the row but not the Asset #. The column is named different in the source and target sheet (Asset # and Asset Num). Do you think this might have anything to do with it?

Paul Newcome

Yes. The column names would need to be the same.

Jeana

I tried making them the same name and I get an error saying you can't have an auto-generated number with the same name in the target sheet. UGH!!! This one will kill me. I just want to copy a row to another sheet that contains an auto-number. :-)

Paul Newcome

Ok. Lets try this...

Add a text/number column to the source sheet. Enter this...

=[Asset Number]@row

This will pull the data into a column that is NOT system generated.

See if that text/number column copies over.

Jeana

Thanks Paul!

Paul Newcome

Finally!! Happy to help! 👍️