· 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
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.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
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).
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
Smartsheet should have option to copy a specific action and reuse it within the Automation. This will save a lot ot time of building Automation where repeative action needs to be places under different condition. Similar faicility is available in Microsoft Power Automate where user can copy some aciton and reuse the same…
Hi, Currently when one wishes to link a form in a dashboard (not display a form, i mean hyperlink! but guess it would apply to forms in a dash too) You would need to get the url first of the sheet where the form derives from. Instead, it would be handy that when adding a hotlink, it would pop-up when 'Smartsheet item' is…
It would be fantastic if there was a built in way to group reports by month or year based on a date column. Something in the group settings when you choose group. If you select a date column you would have these options Oldest to Newest by Year Oldest to Newest by Month Oldest to Newest by Day Newest to Oldest by Year…
©2024. All Rights Reserved Smartsheet Inc.