I have a Google Sheet, that I am using as a tracker for a game. This was not written by me, just passed down, and I am having a hard time trying to decipher the issue here. As per the title of the question, it gives me the error "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col1" The way it is meant to work, is that there are filter cells to use to filter the list, that is pulled from the other sheets in the worksheet. Any advice would be appreciated.
=QUERY(OC_HISTORY_FILTER(OC_History_Data!B2:L, Members_Unique_Data!A2:B, M9), "SELECT * WHERE "& IF(M7<>"", "Col1>="&M7, "1=1") &" AND " & IF(N7<>"", "Col1<"&(N7 + 1), "1=1") & " AND "& IF(O7<>"","Col2='"&O7&"'","1=1") &" AND "& IF(N9<>"", "Col9='"&N9&"'", "1=1") &" AND "& IF(O9<>"", "Col10='"&O9&"'", "1=1") &" AND "& IF(M11, "1=1","Col5!='Success'") &" AND "& IF(N11, "1=1","Col5!='Fail'") &" ORDER BY Col1 " & IF(O11, "DESC", "ASC") & " LIMIT 500")
OC_HISTORY_FILTER()
function returnsnull
,undefined
or a zero-width of zero-height array? See what it returns if you run it without thequery()
wrapper.OC_HISTORY_FILTER(OC_History_Data!B2:L, Members_Unique_Data!A2:B, M9)
into an empty cell and see what it returns. Simply removing Query won't work.