I’m trying to get IMPORTRANGE to work for me with no success. I made two simple spreadsheets: Destination Sheet and Source Sheet. In the destination sheet I’m using the import range function:
=importrange(“1-5F1_zz0ZpGj7SfeQhewsCe0CsrA0eyPbjfmUrLBsyk”,”Sheet1!a1:a1”)
I tried already:
- Replacing the , with ;
- Referencing just the key as well as the full URL in the first argument
- Switching from “ to ‘
- With the sheet name and without it
Not sure what else to do.
Any ideas?