Help

Chronological Date Order for Grouping from Concatenate Field

Topic Labels: Formulas
Solved
Jump to Solution
468 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kiersten_Kollin
6 - Interface Innovator
6 - Interface Innovator

We leverage a concatenate field to be able to indicate when milestones fall during certain weeks. We are wondering if there is a way to revise the formula so that we can have the grouping be in order chronologically by year. I have supplied the formula that we have and how the grouping is appearing today below.

 

Screenshot 2024-08-07 at 1.31.57 PM.png

Screenshot 2024-08-06 at 3.22.27 PM.png

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you're going to need to make the formula lead with the date and the year specifically I'm afraid

As a workaround, perhaps you could just filter out laste year's data?  Or maybe group by the year first?

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you're going to need to make the formula lead with the date and the year specifically I'm afraid

As a workaround, perhaps you could just filter out laste year's data?  Or maybe group by the year first?

Kiersten_Kollin
6 - Interface Innovator
6 - Interface Innovator

Thank you! Switching the year to the front made all the difference.