I am trying to pull the data from sheet 1, using the following formula:
=query(Sheet1!A1:V1850,"select I,A,D,E,F,H,R,S,L, M,O where I = 'TODAY()'")
So I do not have to enter todays date every time. How can it get it to pull that information?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
To select the rows with today's date, the query string should be of the form
=query(..., "select ... where I = date '" & text(today(), "yyyy-mm-dd") & "'")
date 'followed by
', achieving the required format.
Putting 'TODAY()' within a double quoted string does not make it a formula: it's just the word TODAY(), treated as a part of that string. Formulas should be kept outside of strings, with their output concatenated to them as shown above.