Hi everyone, I love this ORDERBY() expression, and it’s already extremely useful, however I wanted to enhance its usefulness even more by adding another column condition to the end (like Excels top-down approach to columnsort). Is this possible to achieve by changing my expression ever so slightly?
My current expression (being used in an attachment template) is as follows…
<<Start: ORDERBY(FILTER(“Timesheet”, AND( [Status] = “COMPLETE”, [Date] >= [From], [Date] <= [To])), [Machine])>>
What I would like to do is sort by [Machine], as well as another column (e.g Type / Date / Name etc).
Hopefully this is doable, and if so doesn’t require a lot of tweaking.
Thanks for reading guys.