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

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…