I’m attempting to apply multiple filters to a spreadsheet and have successfully created two separate queries. However, I am struggling to combine them into a single query.
For name validation, I used the following formula:
=QUERY('Response Evaluation'!A1:K, "SELECT * WHERE 1=1 " & IF(D2="All Masters", "", " AND D = '" & D2 & "' "), 1)
For filtering by date, I utilized this query:
=QUERY('Response Evaluation'!A:K, "SELECT A, B, C, D, E, F, G, H, I, J, K WHERE A >= DATE '" & TEXT(G2, "yyyy-mm-dd") & "' AND A <= DATE '" & TEXT(H2, "yyyy-mm-dd") & "'", 1)
As I am quite new to coding, could someone guide me on how to combine these two queries into one that effectively filters all desired criteria?