Khắc phục lỗi:

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 1, column 43. Was expecting one of: "true" ... "false" ... "date" ... "timeofday" ...

Lỗi:

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 1, column 43. Was expecting one of: "true" ... "false" ... "date" ... "timeofday" ...

Lỗi này khắc phục bằng cách thên dấu "`BY`" vào giá trị BY để tránh né Google Sheet hiểu nhầm.

Từ khóa:

Khắc phục lỗi: Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 1, column 43. Was expecting one of: "true" ... "false" ... "date" ... "timeofday" ...