You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have a calculated date/time column that I want to sort on. The parent issue has formula to set it to the max date/time of the children. I put in a sort into the automation and it sorts properly. But when I filter on an attribute the results are incorrectly sorted since the automation sort does not rerun using the calculated columns new values
Child 1, 10/1/2023
Child 2, 10/2/2023
When the structure comes up A is sorted by the max date of it's children (10/2/2023). But when I run a transformation filter that removes Child 2 based on an attribute, Issue A's date is changed to 10/1/2023. The problem is it's now no longer in correct sort order. I know I can then sort on the column, but that's one more step to explain to my users. Is there a way to make this work as part of the filter on the attribute or another way.
Hello @larry joseph
I'm afraid your setup is not clear. For example - if a child 2 with date 10/2/2023 is removed, why shouldn't the parent's date switch to 10/1/2023 since it's the only source of dates left in the structure. We would need to know more about how the structure is built and what you want to see as a result of the filtering to be able to provide any specific recommendations.
Please reach out to us directly at our support portal - we'll take a closer look at your structure and see what can be done to solve this matter.
Thank you for reply. The parent date should change to 10/1/2023, but now it's not properly sorted relative to the other records. Hopefully better example:
Parent issues have formula to set their date to max date of their children
Issue A (date without filter = 10/10/2023, with filter on Attribute = Y is 10/1/2023)
Child 1, 10/1/2023, Attribute = Y
Child 2, 10/10/2023, Attribute = N
Issue B (date without filter = 10/5/2023, with filter on Attribute = Y is 10/4/2023)
Child 1, 10/4/2023, Attribute = Y
Child 2, 10/5/2023, Attribute = N
Issue C (date without filter = 10/3/2023, with filter on Attribute = Y is 10/2/2023)
Child 1, 10/2/2023, Attribute = Y
Child 2, 10/3/2023, Attribute = N
Without the filter they sort, descending, A, B, C. I have added a sort on the formula in the automation and it works. But if the filter on Attribute = Y is on then they should be sorted B, C, A. But since the sorting is part of the automation, it doesn't re-sort after the filter is applied. I would like a way to get it to re-sort as part of the filter / when the filter is applied the sorting is maintained properly. I am sharing this Structure to a large group of users and it needs to be easy to use, so would prefer to not have to tell them to apply filter then re-sort. I'm sharing this out as a link to the base Structure and have set a default view that has the columns and formulas that are needed.