I've duplicated a Google Spreed Sheet from one that is work fine into another one, and this error appear. How can i fix it
Did you copy the full file or just the tab/function? If not the full file, then the code necessary to run the function wasn't copied over and would explain why it's not working.
I am facing the same issue. The file was copied as Supermetrics -> Duplicate this file for other account and when I am trying to modify the query via the sidebar (eg add another account) I get the #name error.
After playing around a little bit I found out that if I refresh at least 1 query before modifying it then there are no issues with modification. Looks like a bug or at least not very intuitive behavior.
Could you please have a look.