· 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.
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
Dear Smartsheet, You really need to add an administrator-controlled option to manage the license banner display for free users. The banner not being able to be removed by the administrators presupposes that the administrator wants the free users to have licenses. One of the main reasons we love Smartsheet is the ability to…
