Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question