Stop Smartsheets.com from sorting spreadsheet alphabetically by the first column

How can I stop Smartsheets.com from sorting my online spreadsheet alphabetically by the first column?

I have pasted this spreadsheet directly from Excel 2016 and I want it to stay sorted in the original order; I don't want the spreadsheet to be sorted by alphabetically by the first column within Smartsheets.com.

How can I prevent Smartsheets.com from sorting my online spreadsheet alphabetically (so it will retain its original sorting)?

Find more posts tagged with

Sheets

Support

Comments

Chris McKay

If you want to stop Smartsheet sorting automatically without having to reapply filters/sorts, first hide the Primary Column (the one in bold) and then paste your data in from Column 1 onward (or whatever your remaining columns are named).

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…