-
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…
-
Resource Management: Enable row sorting by the clicking on a column header
In Smartsheet Resource Management the Analytics reports come out sorted by the first column, but it would be helpful to be able to sort by any column in the report by clicking on the column header. Presently, the only way to do that is to export to a CSV file, import into Excel, Google Sheets, Smartsheet, etc. and then…
-
IS there a way to sort/filter rows from Newest to Oldest?
Hello everyone, I am trying to create a filter where it puts the rows from Newest to Oldest. For some context, we use this Smartsheet log to capture customer requests and this log has requests from 2022 (being at the top) until now (we're in 2024, being at the bottom). We're always having to scroll all the way down to the…
-
Chart Widget - Reverse X Axis Data
We read left to right in the US and therefore in the US data on a chart is most easily understood left to right. I am after ability to chart ascending dates while maintaining dynamic chart growth from new form submissions. However, Smartsheet data collection by form is best collected, reported, displayed, used in formulas,…
-
Grouping without sorting by that grouping?
I have a row report that I need grouped by one column and sorted by a different column. The grouped column is sorted as text and is showing 1, 10, 11, 12...2, 20,21... The column that I want to sort on is sorted as a number which is correct. Any ideas on how to break what SmartSheets has built in?
