I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc. 

I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again. 
I am not sure what is happening. 
I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK

​I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc. I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again. I am not sure what is happening. I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK  Read More

​