Formula - Filter Function

[sprigelz]

Good day,

My Filter formula seems to have broken when I added a new line to the referenced table. Any ideas as to why this is showing a #VALUE error?

Error occurs even if there is data in any of the O1, O2, & O3 cells that match the referenced table.

=IF(O1<>"",FILTER(TrainingTrack[@[First]:[Entered Date]],TrainingTrack[Department]=Reports!O1),IF(O2<>"",FILTER(TrainingTrack[@[First]:[Entered Date]],TrainingTrack[Training Event]=Reports!O2),FILTER(TrainingTrack[@[First]:[Entered Date]],TrainingTrack[Last]=Reports!O3)))

 

[Fluff]

You need to remove the @ sign from the formula.

 

[sprigelz]

I knew it had to be something simple. Haha. Thank you so much!

Working solution;

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

 

[Fluff]

You're welcome & thanks for the feedback.