A
A
AShimina2021-12-10 17:41:45
Google Sheets
AShimina, 2021-12-10 17:41:45

When using the QUERY function with IMPORTRANGE, the values ​​\u200b\u200bare displayed fine, but if a column with a date is added to the array, then everything breaks. Why is that?

When using the QUERY function with IMPORTRANGE, the values ​​\u200b\u200bare displayed fine, but if a column with a date is added to the array, then everything breaks. Why is this happening.

Here is an example source table: i.imgur.com/MJfwWr3.png

Using a formula, I transfer data with a condition. I stretch the formula to all the cells of the table.
=ARRAYFORMULA(QUERY(QUERY(IMPORTRANGE(" https://docs.google.com/spreadsheets/d/1MPsuPOeuDi... ");"select Col18, Col17 WHERE Col18 = '"&R2&"'"); "SELECT * offset 1"))

It turns out such a sign: i.imgur.com/sGI2Ro9.png

I want to add a column with dates to the formula, the table breaks.
Formula: =ARRAYFORMULA(QUERY(QUERY(IMPORTRANGE(" https://docs.google.");"select Col18, Col17, Col19 WHERE Col18 = '"&R2&"'"); "SELECT * offset 1"))
The resulting table: i.imgur.com/32Y8J5h.png

Please help, or understand how to solve this problem.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question