I have tried using:
=QUERY('Noah''s Weight'!A:D, "select * where A > date ' " &text(TODAY()-15;"yyyy-MM-dd" ) &" ' ")
Row 1 is the headers, column A is the time stamp from the form, and column 2 has the accompanying values I'm looking for.
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