Moving from Test Smartsheet to using real data - Smartsheet

Sue Vaeth

This Community is awesome. Thanks for all the help you didn't know I got from here. This is a question whose answer I can't find.

We recently created a Smartsheet for tracking procurement data. In testing, we've used 15 or so rows. It doesn't appear I can delete the rows and start from Row 1 and have the built-in Smartsheet ID (auto number) begin with 1. The Smartsheet ID wants to count the test data to assign an ID, but it steadfastly refuses to do that.

Can I just overwrite the test data with real data without complications from the test data?

Should I copy the Smartsheet as a new sheet and start fresh?

Thanks for your recommendations.

Andrée Starå

Hi @Sue Vaeth

I hope you're well and safe!

In short, I think it's something like this.

• Chance the column to a text column
• Save
• Delete the contents in the column
• Save
• Change it back to an auto-number column and change the starting number (maybe not needed)
• Save

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!