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
Post a Comment