Sort Date-Groups logically

Description

Hey there,

at the moment the sorting of groups by date is not very logical. Would it be possible to adjust this sorting?

What are you trying to achieve

Sort groups by date from past to future

@Rego91 I’m able to sort the groups correctly by using the ascending sort option on my board. Could you share a bit more about what you’re looking for or how the sorting isn’t working on your side? I’d be happy to help!

Hi @Rego91,

Good request. In the meantime you can try grouping by a formula.

IF(DAYS({Date}, TODAY()) >= 1, "[0] Future",
   IF(DAYS({Date}, TODAY()) >= 0, "[1] Today",
      "[2] Past"))

For example, this formula sorts dates into groups of [0] Future, [1] Today, and [2] Past. The groups will then be sorted by the numbers in brackets.

You can expand the logic into different groups.