I'm trying to do an IMPORTRANGE with query with checkbox. However I keep encountering parse error.
=QUERY(IMPORTRANGE("1pzzOzjtJ8GJOWnkBozdO0anKHnbeREvadEc4rzY4ezI",'Guest Speaker Tracking'!F4:O"),"select * where Col5=TRUE",1)
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI'm trying to do an IMPORTRANGE with query with checkbox. However I keep encountering parse error.
=QUERY(IMPORTRANGE("1pzzOzjtJ8GJOWnkBozdO0anKHnbeREvadEc4rzY4ezI",'Guest Speaker Tracking'!F4:O"),"select * where Col5=TRUE",1)
Replace
'Guest Speaker Tracking'!F4:O"
by
"Guest Speaker Tracking!F4:O"
Add a quotation character and remove apostrophes on the second argument of IMPORTRANGE