Google查询按预期停止工作

Question

一天前我把下面的公式做得很好.在那里，它会给我找到的前两个结果，他们将在一个细胞下另一个。我不得不重置表单响应目的地，但实际上重新创建了它。在昨晚的更改之后，他们开始以不同的格式显示，在一个单元格中显示多个名称，而不是在第一个单元格/行中显示一个名称，然后在下一个单元格/行中显示第二个名称。

"=IFERROR(QUERY('1ON1FORM'!$O$3:$AX, "select AX where O contains date """&text(B17,"yyyy-mm-dd")&""" and O contains timeofday """&text(C17,"HH:mm:ss")&""" or P contains date """&text(B17,"yyyy-mm-dd")&""" and P contains timeofday """&text(C17,"HH:mm:ss")&""" or Q contains date """&text(B17,"yyyy-mm-dd")&""" and Q contains timeofday """&text(C17,"HH:mm:ss")&""" or R contains date """&text(B17,"yyyy-mm-dd")&""" and R contains timeofday """&text(C17,"HH:mm:ss")&""" or S contains date """&text(B17,"yyyy-mm-dd")&""" and S contains timeofday """&text(C17,"HH:mm:ss")&""" or T contains date """&text(B17,"yyyy-mm-dd")&""" and T contains timeofday """&text(C17,"HH:mm:ss")&""" or U contains date """&text(B17,"yyyy-mm-dd")&""" and U contains timeofday """&text(C17,"HH:mm:ss")&""" or V contains date """&text(B17,"yyyy-mm-dd")&""" and V contains timeofday """&text(C17,"HH:mm:ss")&""" or W contains date """&text(B17,"yyyy-mm-dd")&""" and W contains timeofday """&text(C17,"HH:mm:ss")&""" or X contains date """&text(B17,"yyyy-mm-dd")&""" and X contains timeofday """&text(C17,"HH:mm:ss")&""" or Y contains date """&text(B17,"yyyy-mm-dd")&""" and Y contains timeofday """&text(C17,"HH:mm:ss")&""" or Z contains date """&text(B17,"yyyy-mm-dd")&""" and Z contains timeofday """&text(C17,"HH:mm:ss")&""" or AA contains date """&text(B17,"yyyy-mm-dd")&""" and AA contains timeofday """&text(C17,"HH:mm:ss")&""" or AB contains date """&text(B17,"yyyy-mm-dd")&""" and AB contains timeofday """&text(C17,"HH:mm:ss")&""" or AC contains date """&text(B17,"yyyy-mm-dd")&""" and AC contains timeofday """&text(C17,"HH:mm:ss")&""" or AD contains date """&text(B17,"yyyy-mm-dd")&""" and AD contains timeofday """&text(C17,"HH:mm:ss")&""" or AE contains date """&text(B17,"yyyy-mm-dd")&""" and AE contains timeofday """&text(C17,"HH:mm:ss")&""" or AF contains date """&text(B17,"yyyy-mm-dd")&""" and AF contains timeofday """&text(C17,"HH:mm:ss")&""" or AG contains date """&text(B17,"yyyy-mm-dd")&""" and AG contains timeofday """&text(C17,"HH:mm:ss")&""" or AH contains date """&text(B17,"yyyy-mm-dd")&""" and AH contains timeofday """&text(C17,"HH:mm:ss")&"""limit 2"),"")"

我需要公式只显示前两个。是什么改变了这个显示的方式？

注意……我知道这是一个非常长的公式，我很想知道如何减少它，或者以某种方式将它包含在脚本中，但是在我设法使它正常工作之后，我放弃了。

Answer 1

谢谢大家

在这里找到了解决方案https://productforums.google.com/forum/#!topic/docs/6XNpHLGOOpw

现在一切都很好。

0:的魔力)

快乐的日子！