我尝试使用查询(importorange函数）组合来自范围A2的3个不同的数据表:o Col1,Col4,Col5,Col6,Col8,Col11,Col12,Col13,Col14,Col15。我尝试使用下面的公式，但它说
公式分析错误
https://docs.google.com/spreadsheets/d/1ecemy6zdrihrtjhvwlm0xnyp4ayop4ynz_bp9azlnym/edit？usp=共享
=QUERY(
{
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'Termination Review'!A2:O");
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'2nd Week Warning'!A2:O");
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'In Review'!A2:O"); },
"Select Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 ORDER BY Col1 ASC",1 )
它不喜欢第三个污点后面的最后一个分号。如果我把它取出来，我就会得到另一个错误，因为我无法访问您的工作表：
=QUERY(
{
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'Termination Review'!A2:O");
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'2nd Week Warning'!A2:O");
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'In Review'!A2:O") },
"Select Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 ORDER BY Col1 ASC",1 )
