I am trying to create a spreadsheet that imports data from one spreadsheet into another and then sorts that data by a key phrase. Here is the formula I am using:
=Query(Importrange("URL","ReferenceTab!Cell:Cell"), "Select * where Col2 = 'Lost'")
The problem that I am having is that this formula works on some of the tabs in the same spreadsheet, but then in others it causes all of the data to compile into one cell. I have no idea how to fix this.