Aug 07, 2024 10:40 AM
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.
Solved! Go to Solution.
Aug 07, 2024 10:54 PM
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?
Aug 07, 2024 10:54 PM
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?
Aug 09, 2024 08:49 AM
Thank you! Switching the year to the front made all the difference.