Sort Formula Date Columns Correctly

I really want to be able to sort a formula column that has a date. For example I have a formula column that picks the latest of two dates after today, but if I try and sort that column earliest to latest it doesn’t currently recognise the results as a date

Hi @huwrc - you could use General Caster to calculate the formula and cast the result to a Date column, then you can sort on it.

Thanks,
Mark

I use a formula column to determine a target date. I’d like to sort my board by that column soonest due but currently it only sorts month date NOT year. So the 2023, 2024 & 2025 are all mixed together.

Hey Christine!

I hear you on this.

I wanted to check if the existing feature requests relates to what you’re hoping to achieve? If so, we can go ahead and merge your request into it to increase votes and put greater emphasis on its development :pray:

Let me know!

Yes I think that is the same request. I liked that one.

1 Like