Forum Discussion
Filter and Sortby Nested
Hello, I'm trying to sort an array based on a helper column inside a table. =FILTER(SORTBY(countTBL[Name],countTBL[Type],1),(SORTBY(countTBL[Type],countTBL[Type],1)=1)*(countTBL[Shift]="Morning...
kh3ldar Can't be sure without seeing the underlying data, but I think the formula below does what you have in mind.
=SORT(FILTER(countTBL[Name],(countTBL[Type]=1)*(countTBL[Shift]="Morning")))It filters the Name column where Type = 1 and Shift = "Morning". Then it sorts the array in ascending order.