Hi,
I want to use a Kanban view to group items by date. My items have a date-column and I can group the Kanban view by it. But the only problem is that it does not sort in the correct order. So the first column is 18 April, second 30 April and the third 21 April. Anyone a solution to solve this?
Thanks in advance!
One solution to sort items in a Kanban view by date is to convert the date-column values into a format that can be sorted lexicographically. One common format that works well for this purpose is the ISO 8601 date format, which has the format YYYY-MM-DD. You can follow these steps:
Ensure that your date-column contains dates in a consistent format. If not, you may need to reformat the date values in your date-column to a standard date format such as YYYY-MM-DD.
Create a new column in your Kanban view, let’s call it “Sort Date”, and set its values to be the formatted dates from the date-column. You can use a formula to convert the date values into the ISO 8601 format. For example, if your date-column is named “Date”, you can use a formula like this in the “Sort Date” column:
=FORMAT_DATE(‘YYYY-MM-DD’, {Date})
Group your Kanban view by the “Sort Date” column. This will group the items based on the formatted dates in ascending order, which should result in the correct chronological order.
You can further customize your Kanban view by adding additional columns or applying filters as needed.
By following these steps, you should be able to use the Kanban view to group items by date and have them sorted correctly based on the “Sort Date” column in the ISO 8601 date format.
@JoeSuarez
I use Glide Tables so thought it was possible to use the ‘format date’ standard formula provided by Glide. When I use ‘YYYY-MM-DD’, this happens:
I also tried ‘yyyy-MM-dd’ which gives a correct date, but it does not sort correctly in the Kanban view.
Do you know what I’m doing wrong?
Can you show us the configuration of your Kanban component? How many days you want to show as “groupings”?
@ThinhDinh, I would like at least 5-7 days as ‘groupings’. Here is the configuration:
