· Problem: It is not possible to sort a column containing dates by chronological order
· Use Case: list of annual leave for employees working on a project
· Ideal Solution: Enable sort by: chronological order for a column containing dates
Sign in to see the current vote count, add your own vote, or leave a comment.
You can sort by dates. It would be either ascending to have the earliest dates at the top of the sheet or descending to have the most recent dates at the top of the sheet.
Hi Paul, it does not work with English time format unfortunately (31/12/2023) because it sorts the column by the first digit only (the day) and therefore some later months are before others meaning that the list is not in chronological order.
Have you double checked that you have date values in a date type column? I just tested it in an account that uses that formatting, and it sorted properly. In the below snippet, you will see where it is actually sorted on the date and not necessarily the day number (first two rows).
I am trying to sort a column with dates however the sort button is grayed out.
@Summerbreeze19 The first thing I would check is filters. You cannot sort while a filter is applied. You have to sort first then filter.
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
Smartsheet does not currently send automated error notifications to Pivot workflow owners when workflows fail, unlike the notification behavior for DataTables, Data Shuttle, and Meshes. Also, when column mappings break on a mesh, the mesh will continue to run with an error. We should expect the same functionality from a…
