This is used to grab information from two spreadsheets with the same number of columns, with PRI grabbing data with headers and NON grabbing just data.
"select A, B, C, D, E, I, J, K, L, M, N, O, P, Q, R, S, T WHERE A >= date'" & TEXT(B2,"yyyy-mm-dd") & "' and A <= date '" & TEXT(C2,"yyyy-mm-dd") & "'"
This is the reference for the query to look up the start and end date based on two specific cells.
The query using D1 will filter if both spreadsheets have an entry in a specific date range.
EX: PRI and NON both have an Apr7 entry which the query shows both if START is Apr7 and END is Apr13.
But the issue is if only one of the two spreadsheets has an entry then the query shows nothing if the START and END criteria are still correct despite their being an entry between the date criteria.
Is there a way for the query to recognize both spreadsheets at the same time, instead of a "only run if BOTH PRI and NON have an entry" behavior? I definitely feel the query itself is the problem but I could not find any format that works alongside D1.