Я ищу способ использовать эти два запроса ниже в 1. Я много пробовал, но каждый раз получал ошибку. Я тоже искал в гугле, но ничего не нашел. ваша помощь будет оценена
№ 1
=ARRAYFORMULA(UPPER(QUERY({IMPORTRANGE(Links!D10,"Sheet16!A3:AX1000"),IF(ISDATE_STRICT(IMPORTRANGE(Links!D10,"Sheet16!G3:G1000")),"No Show","Checked")}, "Select Col1, Col10, Col44, Col11, Col12, Col13, Col14, Col18, Col20, Col21, Col22, Col23, Col25, Col27, Col28, Col29, Col32, Col33, Col34, Col35, Col38, Col39, Col40, Col41, Col42, Col43 WHERE Col12 is not null ORDER BY Col10",0)))
НЕТ. 2
=ARRAYFORMULA(UPPER(QUERY({IMPORTRANGE(Links!D11,"Sheet16!A3:AX1000"),IF(ISDATE_STRICT(IMPORTRANGE(Links!D11,"Sheet16!G3:G1000")),"No Show","Checked")}, "Select Col1, Col10, Col44, Col11, Col12, Col13, Col14, Col18, Col20, Col21, Col22, Col23, Col25, Col27, Col28, Col29, Col32, Col33, Col34, Col35, Col38, Col39, Col40, Col41, Col42, Col43 WHERE Col12 is not null ORDER BY Col10",0)))
пытаться:
=ARRAYFORMULA(UPPER(QUERY({{
IMPORTRANGE(Links!D10, "Sheet16!A3:AX1000");
IMPORTRANGE(Links!D11, "Sheet16!A3:AX1000")}, IF(ISDATE_STRICT({
IMPORTRANGE(Links!D10, "Sheet16!G3:G1000");
IMPORTRANGE(Links!D11, "Sheet16!G3:G1000")}), "No Show", "Checked")},
"select Col1,Col10,Col44,Col11,Col12,Col13,Col14,Col18,Col20,Col21,Col22,Col23,Col25,Col27,Col28,Col29,Col32,Col33,Col34,Col35,Col38,Col39,Col40,Col41,Col42,Col43
where Col12 is not null
order by Col10", 0)))