Feb 04 2021 03:49 PM
I am running google sheets, Currently for this project.
I am using a query function to pull information based off an original response sheet to populate another sheet, however the column BY is a needed column in this populated sheet and is returning a query error.
=query('Form Responses 2021'!1:102, "select B,A,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,AA,AB,AC,AD,BU,BV,BW,BX,BY,BZ where C=""SSF""","1")
It works until I add the BY column and it returns the following error
#VALUE
Feb 04 2021 03:58 PM
@DMills74 You realize this is a Microsoft Excel forum not a Google Sheets forum right?
I also use sheets but never used this "Query" function so looked it up to learn what it is and notice the last parameter is Number of Columns and you are passing "1". Shouldn't that be a number and not text?
Feb 04 2021 04:08 PM
Yes I do understand this, however most people who are excel knowledgable are also fairly google sheet knowledgeable except a few nuances such as this query function from time to time, but it is not too much out of their scope and I can usually trust those on this forum over many others for great answers so I tend to dig a little here first.
Not quite sure your question However. Where C=""SSF"" is specifically looking for SSF in column C and returning the info based on the select function of Columns,
The problem is the BY Column is apparently also a function of some sort where it changes the function to look for the error it shows. Where BY is a column name it apparently triggers something in this particular query function. No other Column I have found does this error