Issue with FILTER function

[missingsc]

I'm having an issue with a FILTER function that is just sending back a value of #N/A and the error help obviously doesn't say too much. Hoping someone here can help.

My formula is
=FILTER(TimetrackedLogs!$A$2:$N$200000,TimetrackedLogs!$N$2:$N$200000="my_value","No results")

Column N in the TimetrackedLogs sheet has a formula in it to calculate its value. However, for testing I've also replaced that formula with a literal value and get the same #N/A result from the FILTER function. Can anyone see what my issue here is with this formula? Happy to send in more data if needed.

Thank you!

 

[Cubist]

Please post sample data where you're encountering the issue.

 

[StephenCrump]

I suggest you also check whether you have a #N/A value anywhere in TimetrackedLogs!$N$2:$N$200000

 

[missingsc]

I suggest you also check whether you have a #N/A value anywhere in TimetrackedLogs!$N$2:$N$200000

This was the problem! By wrapping the formula in the TimetrackedLogs column N in an IFERROR function it fixed the problem. Thank you so much for the help!!!