Filter and Sortby Nested

Copper Contributor


I'm trying to sort an array based on a helper column inside a table.




This is my messed up formula.

I need to filter names by countTBL[Shift] and then sort countTBL[Name] by countTBL[Type] in ascending order but I haven't been successful.

I'd greatly appreciate your assistance.

1 Reply

@kh3ldar Can't be sure without seeing the underlying data, but I think the formula below does what you have in mind.


It filters the Name column where Type = 1 and Shift = "Morning". Then it sorts the array in ascending order.