Sorting records in ACS order without Due Dates
O
Omar Cabello
When sorting records by Due Date in ASC order, I would like the records without due dates to appear after the records with Due Dates. Currently records without Due Dates appear first in the list. The only way to fix this is to Group by "Due Date" and sort the Due Date group in DESC order, however it would be great if we achieve this without Grouping by Due Date?
Canny AI
Merged in a post:
Sort (ascending) function should place null values BELOW all other records.
J
Johnny Bravo
Smartsuite ascending column sorting places null values above records with non-null values. This incorrectly prioritizes items that do not include relevant sort data, and is the opposite behavior of every other spreadsheet/database tool (excel, sheets, etc.).
Use Case: I want to sort a list of ranked items where 1 = highest rank, 5 = lowest rank. "Sort 1-9" will currently place items with no rank value above rank 1, while I want (and expect) them displayed below rank 5.
At least provide users with the option to enable this functionality.