最近我发现一个脚本读取目标电子表格的范围,其中包含从源电子表格电子表格导入的数据(使用IMPORTRANGE函数)偶尔(但不总是)返回虚假值 . 为了检查错误,我按小时触发脚本并得到以下结果 .
Timestamp Value of cell B4
3/14/2018 19:46:15 Biochemistry
3/14/2018 20:16:14 Biochemistry
3/14/2018 22:07:32 #ERROR!
3/15/2018 0:07:32 #ERROR!
3/15/2018 2:07:34 #ERROR!
3/15/2018 4:07:31 #ERROR!
3/15/2018 6:07:34 #ERROR!
3/15/2018 8:07:22 Biochemistry
3/15/2018 10:07:22 Biochemistry
3/15/2018 12:07:09 Biochemistry
3/15/2018 14:07:32 Biochemistry
3/15/2018 16:07:33 #ERROR!
3/15/2018 16:20:40 Biochemistry
3/15/2018 18:07:23 Biochemistry
3/15/2018 20:07:28 Biochemistry
3/15/2018 22:07:23 Biochemistry
3/16/2018 0:07:22 Biochemistry
3/16/2018 2:07:34 #ERROR!
3/16/2018 4:07:33 #ERROR!
3/16/2018 6:07:33 #ERROR!
3/16/2018 8:07:33 #ERROR!
3/16/2018 10:07:33 #ERROR!
3/16/2018 12:07:22 Biochemistry
3/16/2018 14:07:22 Biochemistry
3/16/2018 16:07:33 #ERROR!
3/16/2018 18:07:24 Biochemistry
3/16/2018 20:07:35 #ERROR!
3/16/2018 22:07:24 Biochemistry
3/17/2018 0:07:23 Biochemistry
该脚本读取目标表单的单元格“B4”,其中包含以下公式'= IF(MONTH(TODAY())<6,IMPORTRANGE(“SOURCE SHEET1 ID”,“SHEET1!B4:B”),IMPORTRANGE(“ SOURCE SHEET2 ID“,”SHEET1!B4:B“)' .
当我打开目标电子表格来检查错误时,一切都看起来很好,所有数据都按预期导入 . 我还制作了目标电子表格的副本,并在新电子表格上尝试了脚本,但结果是一样的 .
可能是什么问题呢?