I am pulling information from one tab to another and I believe this is why it will not allow me to sort (because it is not sorted in the original tab). The easy solution would be to sort that tab. However, this is not an option. Is there something I can add to my query code to allow it to sort column A by ascending? My query code is here =Query('Tardy Data Sheet'!L17:R, "Select * Where N = '8th'")

  • Welcome to Web Applications. Please add a brief description of your search/research efforts as is suggested in How to Ask. Also add some sample data.
    – Rubén
    Sep 30, 2020 at 22:52
  • =Query({'Tardy Data Sheet'!A17:A,'Tardy Data Sheet'!L17:R}, "Select Col2, Col3, Col4, Col5, Col6, Col7 Where Col4 = '8th' Order by Col1 Asc")
    – Oleg_S
    Oct 1, 2020 at 7:50

1 Answer 1


Try =Query('Tardy Data Sheet'!L17:R, "Select * Where N = '8th' Order by A")

OOPS, Didnt notice ColA isn't in your query range... Use A17:R

  • Thank you for your help. It did not work, I did get a message that said, "unable to parse query string for function query 2: No_Column A Sep 30, 2020 at 19:29
  • This is correct regarding the use of order by but we don't know if by Column A the OP is referring to 'Tardy Data Sheet'!A:A or to the Column A of the sheet holding the formula.
    – Rubén
    Sep 30, 2020 at 22:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.