I’ve setup a google form to autopopulate a google sheet, and pln to use the google sheet to autopopulate other google sheets.
I’ve been able to populate other tabs within the same sheet with the latter half of this formula:
=query(importrange("https://docs.google.com/spreadsheets/d/15YSbXULVG7PqORsAKV43JYENZww5g6q3NrkEVcyddvc", "Master!A1:Z3000"), "Select * where B = 'Demon’s Souls' and H = 1 and J = 0", 1)
However, when I try using this in another google sheet, I get a Formula Parse error.
I’m assuming that my issue is in the Importrange section. I’ve verified address is correct, but cannot figure out why this will not work.
Thanks for any help.
Edit: Am now getting a value error? Yippee