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?
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?
Excel Formula:
=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)))