Formula - SortBy and Filter Function

[sprigelz]

Hello again!

Just updated the formula and once again I seem to have broken something. The formula works just fine when the second (O2 - Training Event) and third (O3 - Last Name) conditions are entered, but for some reason breaks on the first (O1 - Branch) condition. Help?

=IF(O1<>"",SORTBY(FILTER(TrainingTrack[[First]:[Entered Date]],TrainingTrack[Department]=Reports!O1),TrainingTrack[Date Completed],-1,TrainingTrack[Last],1),IF(O2<>"",SORTBY(FILTER(TrainingTrack[[First]:[Entered Date]],TrainingTrack[Training Event]=Reports!O2),TrainingTrack[Date Completed],-1,TrainingTrack[Last],1),SORT(FILTER(TrainingTrack[[First]:[Entered Date]],TrainingTrack[Last]=Reports!O3),5,-1)))

 

[Fluff]

Use sort rather than sortby like

SORT(FILTER(TrainingTrack[[First]:[Entered Date]],TrainingTrack[Department]=Reports!O1),{5,3},{-1,1})

 

[sprigelz]

So that fixed it, but I'm curious to know why the SortBy would not work with that?

I've also adjust the second condition to just be Sort under the same conditions. Thank you so much!

 

[Fluff]

With sortby the arrays must be the same size, which they wont be as you filtering out some of the rows & the trying to use the entire column.