Google Docs =Filter() will randomly show "N/A" till I erase the function and paste it back in -


i've been having consistent issue every =filter() function on spreadsheets stop working, display "n/a" "no matches found in filter evaluation". filtering data same sheet, not importing it.

i have copy function, delete it, hit enter apply changes cell, paste in , hit enter apply function again. after work expected.

this happens no rhyme or reason, , affects worksheets in document. how prevent this? there way automatically fix without copy/pasting functions dozens of times on regular basis?

edit: function example

=filter(organize!f2:k1000, organize!d2:d1000 = b6, organize!c2:c1000 =a6, (organize!e2:e1000 = "doug") + (organize!e2:e1000 = "rach owes doug")+ (organize!e2:e1000 = "both")+ (organize!e2:e1000 = "rach owes doug split")) 

this shows "n/a" "no matches found in filter evaluation" till delete , paste in.


Comments

Popular posts from this blog

php - Admin SDK -- get information about the group -

dns - How To Use Custom Nameserver On Free Cloudflare? -

Python Error - TypeError: input expected at most 1 arguments, got 3 -