-
Can I filter or sort by highlighted changes?
I have a project tracker sheet that is set up so that we can import a file from our customer regularly that updates existing worksites, and adds new ones to our tracker sheet. We are able to use "Highlight changes" to easily see what cells are updated and what rows are added. What we would like to be able to do, either in…
-
Assigning Individuals into groups based on qualification and group
I have a bulk list of 2000+ names along with their certification/qualification and affiliated group. I need to come up with an automated way of assigning each of these people into 40 groups. Each group must have a minimum of X numbers of each qualification (ex. Group 1 must have a 2 plumbers, 2 scientists and 10 fisherman,…
-
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 >…
-
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…
-
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…
-
Sorting date via the Grouped-by parameter
In the Report associated with our Dashboard, Smartsheet doesn't seem to allow us to sort by the 'Request Status' columns (which is a Drop-Down menu on the Form and Sheet). Is there a Work-Around? We want these displayed in a particular order based on which step the order is in, based on the Request Status. Thanks for any…