-
Add custom sort button to ribbon
I have a sheet that uses all three tiers of sorting (and could really use a fourth). Every time my sheet updates with new content from its linked form, I have to re-select each tier for the sort. Excel saves the last custom sort, so, even though neither has an automatic sort capability, you only have to do a couple clicks…
-
Sorting with project status, Active, completed, not started
Hi, I'm trying to sort the projects by status. I need the report to list first 'Active' projects, then 'Not Started' and at the end 'Completed'. But when I use sort ascending, it shows 'Active' project then 'Completed' and then 'Not started'. Can anyone help to get the sorting done as per the need. Active > Not Started >…
-
Alphabetical sort for Group Management List
I can't see any activity on this since 4/2023. I really would LOVE this ability!! I have some groups that are 86+ people and it is almost impossible to maintain. Are there any updates you can provide??
-
Why does it take a long time for my report to update its alphabetical order after I rename sheets?
I have a report that I'd like to appear alphabetically. When I update the names of my sheets to reflect 1, 2, 3, etc based on the order I want them to appear, the report doesn't update sometimes until days later. Is there something else I should be doing besides refreshing, signing in, signing out, etc to get this…
-
Merged: Sheet Sort Enhancement
This discussion has been merged.
-
Report Date Sorting - Out of Order
Some of my report dates are sorting out of order, does anyone know why? Master Sheet 1: Dates in a column, both 2024 and 2025 data; Column Type = Date; All reports sort correctly Master Sheet 2: Dates in a column, populated by JOIN(COLLECT), cell formula; Column Type = Date; Master Sheet 2, Related Reports: Sort by "Store…
-
Auto-sort using API
I understand that as of now it is not possible to auto-sort columns in Smartsheet. But is there an API code that can be used to sort columns alphabetically?
-
Sorting by Grouped Status with a custom order
I'm working on a report that has the usual project status "On track, Paused, On hold, In Queue, Delayed Start" etc… I currently have a list of the project name as a line item, then grouped by applicable status. That said, when "sorting", it doesn't give me the option to see which goes at the top or at the bottom, and…
-
Row sorting doesn't work as expected
I have a sheet with a column called Category. This is a drop-down column with options starting with A, B, C, G, L, PL, PP, and S. The items are ordered that way. When I sort the rows using that column, the result is A, C, G, L, PL, PP, S, and B. I have checked for strange characters and the order of the drop-down items and…
-
Sort Rows with criteria
It would be great if you could use the Sort Row function with a criteria option also. For Example: If I had a range of open and closed requests that have different due dates. Sort rows by "Due Date" with due soonest showing at the top but only the rows where the closed box has not been ticked, the rows that are "closed"…
