· 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.
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
